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
Jen McCown
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 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
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,038 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
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
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers