Back Home
And glad to be there. I was gone almost 7 days, home only for 24:15:00 before back out on another...
2010-11-09
819 reads
Blog Posts
Blogging and Saving Money at the Same Time
I enjoy blogging. I enjoy passing on the information that I have gathered over the years. I also enjoy doing...
2010-11-09
602 reads
Day 1 at SQLPASS Keynote Address
Microsoft announced the RTM of SQL Server 2008 R2 Parallel Data Warehouse, which will be available as an appliance in...
2010-11-09
458 reads
Finding CPU Pressure - dm_os_schedulers DMV
The last post dealt with checking CPU pressure using wait_stats DMV. But, to get a complete picture of CPU Pressure,...
2010-11-09
791 reads
First Impressions
SELECT @@Version
Microsoft SQL Server “Denali” (CTP1) – 11.0.1103.9 (X64)
I’ve been playing with the CTP for a few days (with absolutely no...
2010-11-09
1,427 reads
Join Me This Week At PASS
This week at the PASS Community Summit in Seattle, I’m delivering two full length sessions, one lightening session, and chairing...
2010-11-09
331 reads
MS SQL Server 2011 aka Denali, Next Version of SQL Server - CTP 1 Now available!
Ladies and Gentlemen, SQL Server 2011, aka Denali, CTP 1 is now available as public download :
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9
Although, I'm not attending...
2010-11-09
3,556 reads
November 2010 Version of SQL Server 2008 Diagnostic Information Queries
Apparently, when I posted this a few days ago, the Windows Live Writer plug-in that I used mangled the T-SQL...
2010-11-09
1,296 reads
November S3OLV Recap
Last Thursday we had the monthly meeting for our local PASS chapter. I would normally try to get the recap...
2010-11-09
499 reads
November S3OLV Recap
Last Thursday we had the monthly meeting for our local PASS chapter. I would normally try to get the recap out a bit sooner. This month, I intentionally delayed...
2010-11-09
3 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