Video: Designing Stored Procedure Solutions
My new session for 2014, “Designing Stored Procedure Solutions”, is now up on the Sessions page: abstract, video, and code!...
2014-04-28
1,234 reads
SQL Awesomesauce
MidnightDBA at SQL Saturday Houston – May 10
Sean and I will be speaking at SQL Saturday Houston on May 10, at San Jacinto College – South Campus 13735...
2014-04-14
638 reads
Heartbleed bug: immediate security threat for both IT, and consumer sites and services
“An encryption flaw called the Heartbleed bug is already being called one of the biggest security threats the Internet has...
2014-04-10
694 reads
Decree: Set your partition offset and block size – make SQL Server faster
If I’ve said it once, I’ve said it 1,024 times: your SQL data and log drives need a 1024 KB...
2014-04-07
1,494 reads
GetLogSpace – table and stored procedure
We’ve talked before about how to get log space usage information in SQL Server. After the 1,032nd time I re-wrote...
2014-03-31
1,252 reads
SQL Saturday Oklahoma City precon: Becoming an Enterprise DBA
We’ll be at OKC this summer for their SQL Saturday on August 23, and we’re presenting our precon “Becoming an...
2014-03-26
614 reads
The case for SQL Server 2012 Enterprise (vs. Standard) edition
In celebration of the impending SQL Server 2014 release, and in recognition that a large percentage of my clients are...
2014-03-24
1,036 reads
InfoWorld Review: SQL Server 2014, by Sean McCown
InfoWorld Magazine (http://www.InfoWorld.com) has published a new article by MidnightSQL owner Sean McCown, “Review: SQL Server 2014 pushes the pedal...
2014-03-20
711 reads
The problem with PASS Summit abstracts (and submissions and selection and notification and…)
The problem with the PASS Summit session submissions process is that people don’t know why they’re rejected. So say we...
2014-03-26 (first published: 2014-03-19)
1,438 reads
Breaking: SQL Server 2014 RTM in two weeks
Today, MSDN and TechNet are reporting that SQL Server 2014 will be available on April 1, 2014. Thanks to @MariaZakourdaev, who posted...
2014-03-18
815 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers