(Michael Rikmas) A few years ago Yves Trudeau and Aleksandr Kuzminsky wrote posts about different ways for recovering orphaned .ibd files:
Author: SSWUG Research
Find the SQL Server Analysis Services and Reporting Services Version, Edition and Service Pack
(Sadequl Hussain) I have a stand-alone instances of SQL Server Analysis Service (SSAS) and SQL Server Reporting Service (SSRS) running in my environment. How can I find what the version and edition of each package as well as the Service Pack installed?
DB2 editions: Which distributed edition of DB2 10.5 is right for you?
(Amyris Rada and Roman Melnyk, B.) Learn the details of what makes each edition of IBM DB2 10.5 for Linux, UNIX, and Windows unique. The authors lay out the specifications for each edition, licensing considerations, historical changes throughout the DB2 release cycle, and references to some interest
Retrieve Images From SQL Server Database Into Data Grid in WPF Using Data Binding
(Kiran Kumar Talikoti) In this article we will see how to store and retrieve images from a SQL Server Database into a Data Grid in WPF using Data Binding. I am creating the database using the code first approach. Now we will look into the System Requirements.
SQL Server backup best practices
(Roman Rehak) Doing database backups is one of the most important tasks of a database administrator. A seasoned DBA should be able to quickly configure any server for the most suitable database strategy. But many companies have “accidental” DBAs or sometimes even non-DBA employees in charge of datab
Indexing Fundamentals
(Steve Hood) First, lets understand what the types of indexes are. If you take a reference book, you have the two types of indexes. The book itself is a clustered index, it contains all the data and has the key field of page number.
ASP.NET MVC 5 Authentication Filters
(Raj Aththanayake) ASP.NET MVC 5 has some great improvements around authentication. This includes new Authentication filters, new Authentication options and ASP.NET Identity Management.
Implementing Health Monitoring in ASP.NET MVC Applications
(V.N.S Arun) As you introduce more and more functionalities into your website, the chance of exception occurrence in a real production scenario also grows. Some people take time to notify you of the issue that they are facing in your website but many don’t bother and simply stop visiting your site.
ADO.NET: Calculating DataTable Column Totals using SUM
(Ged Mead) In the posts in this series so far, I’ve fetched data and displayed it, usually in rows and columns. In some cases, the data has been filtered on user preferences; in others, data is pulled from more than one table and displayed as a discrete set; and in others, calculations are carried
Missing Information
(mgogala) Since the version 11G it is possible to exclude committed blocks from specific tablespace from being written to flashback recovery area. FBDA process writes committed blocks to flashback area and is quite IO intensive.