March Madness – SQL Server style
Bodypaint not required
It seems that March is another great month for getting your geek on without having to leave the...
2012-03-08
635 reads
Blog Posts
Moving MASTER Database
In my previous post we see how to move MSDB database, today we will see how to move or relocate...
2012-03-08
1,070 reads
SQL Server – netstat monitoring and tuning performance
To display network connections and various network interface statistics – netstat is a handy command – line based tool.
Why is it...
2012-03-08
1,320 reads
What is a Favicon?
If I were to show you the tabs in the following pic without a description, would you recognize the websites to which they belong? I would dare say that...
2012-03-08
4 reads
What is a Favicon?
If I were to show you the tabs in the following pic without a description, would you recognize the websites...
2012-03-08
789 reads
Why I am excited about SQL Server 2012
By now many of you have had the opportunity to hear or see something about the next release of SQL...
2012-03-08
673 reads
Backing up a Certificate
If you create your own certificate in SQL Server, you need to make sure that you back it up immediately....
2012-03-07 (first published: 2012-02-27)
10,714 reads
Enabling Filestream in SQL Server 2012
Filestream is a cool feature, albeit one that’s cumbersome to use in SQL Server 2008 and R2. However the FileTable...
2012-03-07
3,643 reads
I’m sorry, you’ve committed a GIANT INTERNET FAIL (#SQL2012)
Updated with links to no-login goodness. Updated again with IE rage.
This week, Microsoft announced the SQL Server 2012 release to...
2012-03-07
931 reads
Intel Xeon E5-2600 Series Processors Released
Yesterday, Intel finally released the much anticipated Xeon E5-2600 family of processors, also known as Sandy Bridge-EP. This is a...
2012-03-07
1,229 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
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