NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with...
2011-04-06
3,375 reads
Articles
SQL Saturday #73 - Orange County, CA
A free one day training event on Apr 9, 2011 in Huntington Beach, CA. Come learn about SQL Server with a number of SQL Server experts.
2011-04-06 (first published: 2011-03-25)
3,225 reads
Using PowerShell to Manage SQLServer
This article provides a practical example of how Powershell can be used by DBAs.
2011-04-06
4,478 reads
ERDDUG - Introduction to Indexes with SQL Server MVP Gail Shaw
If you are in South Africa near East Rand, join the East Rand Developer and DBA group on April 9 for a presentation by SQL Server expert, MVP, and longtime SQLServerCentral author, Gail Shaw.
2011-04-05
1,420 reads
Industrial-strength database documentation using Extended Properties
To finish this short series on extended properties a look at documenting sets of database objects
2011-04-05
8,625 reads
Change SQL Startup Parameters with PowerShell
Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...
2011-04-05
1,493 reads
SQL Saturday - #74 - Jacksonville
Come attend this free one day training event in Jacksonville, FL on Apr 30, 2011. Meet a number of SQL Server experts and learn about SQL Server at the University of North Florida.
2011-04-05 (first published: 2011-03-24)
1,943 reads
TOP 10 SQL Server Requests That Should Be Automated
What DBA wouldn't want to make their job a little easier?
2011-04-05
6,926 reads
Real World Foreach Loop Container example
Describes different uses of the SSIS Foreach Loop container in one practical scenario.
2011-04-04 (first published: 2008-02-25)
39,854 reads
TSQL Challenge 53 - Finding empty and non-empty intervals
A SQL Server instance is set up to log the session start time and end time into a table. Given this table, your job is to find all time intervals in which no one is logged in.
2011-04-04
1,538 reads
Blogs
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers