SQL Server 2008 Installation Issues - Issues and Workarounds
MVP Robert Pearl explains how to get around some common issues that might occur when installing SQL Server 2008 on Windows 7.
2011-04-28
7,383 reads
Articles
Check your Digits
The most persistent struggle in data processing has been to ensure clean data. There are many ways that data can be incorrect and a database must check, as best it can, that the data is correct. The CHECK constraint is ideally suited for this sort of work, and the checking routine can become quite complex when dealing with check digits in data.
2011-04-28
3,328 reads
When a SQL file will not open in SSMS
What happens when double clicking a .SQL file doesn't open the file in SSMS? This article provides the solution to fixing that annoying SSMS issue.
2011-04-27
14,503 reads
Adding Column to a SQL Server Table
This article examines the difference between adding a nullable column to a table or a column with a default value.
2011-04-27
5,393 reads
Performance Troubleshooting with Windows Resource Monitor - Part 2
In the second part of the Resource Monitor series we conclude with a look using the Memory tab and Disk tab to diagnose performance issues.
2011-04-26
4,198 reads
How to Setup Report Parameters to Default Based On User Credentials
This article explains how to setup Reporting Services (SSRS) parameters default values using user credentials.
2011-04-25
15,475 reads
Backup and Restore of an Analysis Services Database
One of the most important responsibilities of a database administrator is to make sure that all the databases are backed up across environments managed by them. In my earlier article titled Importance of Database Backups and Recovery Plan I discussed the importance of a good database backup and recovery plan for all the user and system databases. In this article we will take a look at the steps which a database administrator needs to follow to backup and restore an analysis services database.
2011-04-25
3,172 reads
SQL Server 2008 R2 Service Pack 1 Customer Technology Preview Available
You can help test the first service pack for SQL Server 2008 R2 and ensure the highest quality possible for its release.
2011-04-25
2,610 reads
ShowPlan Operator of the Week - Split, Sort, Collapse
'Split, Sort & Collapse' is, happily, not a description of the intrepid Fabiano Amorim after his epic series of articles about the ShowPlan operators. With renewed stamina, Fabiano continues his mission to describe all the major operators by explaining the Trivial Plan and the power of unique indices.
2011-04-22
3,882 reads
SQL Server Webinar Series #9: Streamlining SharePoint Recovery
Metalogix Selective Restore Manager streamlines the process of finding and recovering individual documents and lists directly from a SharePoint content database backup file without the need for a recovery farm. When used in conjunction with Red Gate’s SQL Virtual Restore, Selective Restore Manager can recover documents and lists without physically restoring the backup file—saving time and much needed disk space. Together, Metalogix Selective Restore Manager and Red Gate SQL Virtual Restore open up new possibilities for your SharePoint backup and recovery strategy. Apr 21, 2011, 11am EST.
2011-04-21 (first published: 2011-04-12)
3,293 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers