SQL University: Architecting SQL Server Security, the Big Picture
Welcome to this semester's security week at SQL University. In previous semesters we've covered the technical aspects of SQL Server...
2011-02-08
1,933 reads
Blogs
PASS Summit Location
Andy Warren has posted another one of his excellent summaries of what’s going on at the PASS Board. Andy, thanks...
2011-02-08
1,580 reads
A Full Backup can Impact a Log Backup–MCM Prep
In the early days of SQL Server you could not run a log backup while a full backup was running....
2011-02-07
1,926 reads
Importing and Exporting SSIS Packages Using PowerShell
SQL Server PowerShell Extensions (SQLPSX) includes a set of function for working with SSIS which among other things allow you...
2011-02-07
3,226 reads
Microsoft SQL Server Licensing For Dummies..
Don’t let the above title fool you! Have you been confused on the Microsoft SQL Server Licensing requirements? Per Processor, Per CAL, Per Core, Per Socket, Per Node – Per haps (space intended :-), we should revisit the issue again, and try to offer some assistance as you go forward in making your purchasing decisions.
2011-02-04
4,848 reads
Microsoft Support Policies for Windows Server and SQL Server
Microsoft provides ten years of support (five years Mainstream Support and five years Extended Support) at the supported service pack...
2011-02-04
2,138 reads
31 Days of SSIS – Importing Execution Plans (30/31)
31 Days of SSIS
Almost time to wrap up the 31 Days of SSIS. We are down to just two more...
2011-02-03
2,300 reads
My Thoughts on the Intel Sandy Bridge Chipset Recall
I awoke this morning to see a number of stories breaking about the Intel Sandy Bridge H67/P67 Chipset Recall. I...
2011-02-03
1,661 reads
Powershell to Automate SQL Compare
A question came up on the SQL Server Central Forums, how could you use Red Gate SQL Compare to automate...
2011-02-02
2,381 reads
31 Days of SSIS – Exporting Execution Plans (29/31)
31 Days of SSIS
A day late for the twenty-ninth post of the 31 Days of SSIS, but it is still...
2011-02-02
1,236 reads
Blogs
What’s New at AWS re:Invent 2025 – Day2 Highlights
Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote...
Quantum Computing and SQL Server Article Is Up
By Brian Kelley
In parallel with the presentation I gave at the PASS Data Community Summit on...
SQL Server – What To Do When Disaster Strikes (5-Point Survival Guide)
SQL Server – What To Do When Disaster Strikes (5-Point Survival Guide)Chill, coffee first.When...
Forums
Improving update statistics process for 6 big tables
Recently I was asked to investigate the update statistics process on a particular database....
Adding a Lot of Seconds
Comments posted to this topic are about the item Adding a Lot of Seconds
SQL Server Licensing is Simple
Comments posted to this topic are about the item SQL Server Licensing is Simple,...
Question of the Day
Adding a Lot of Seconds
When does this code work and when does it fail?
DECLARE @BaseDate DATETIME = '1900-01-01'; SELECT DATEADD(SECOND, 2147483648, @BaseDate) AS [MaxIntSecondsAdded];See possible answers