A Learning Experiment at SQL Saturday #187– Richmond
In a little over a week, SQL Saturday #187 takes place in Richmond, VA. I’m looking forward to going back...
2013-02-27 (first published: 2013-02-25)
1,152 reads
Blog Posts
Attaching an MDF with no Log (AdventureWorks)
Attaching an MDF file without an LDF file can be a little tricky. I had to go through this recently...
2013-02-27
2,000 reads
Finding SQL Server Installs Using Powershell
Old Dog, New Tricks
I’ve been writing tools for SQL Server for a lot of years. Some of these tools were...
2013-02-27
2,450 reads
It Is Your Fault
I earned my nickname. I’m proud of it. I am the Scary DBA. I don’t really like to advertise my...
2013-02-27
1,532 reads
Optimizing Protected Indexes (was Indexing Encrypted Data)
Why bother encrypting?
Riddle me this batman? Why bother to Encrypt?
As a SQL Server DBA I am primarily responsible for making...
2013-02-27
1,818 reads
Setting up an Internal Friendly URL
Note: This solution is not necessarily the best or most efficient solution in all cases. It is, however, very simple...
2013-02-27
3,310 reads
Thanks to my session attendees
To all of the wonderful attendees to both the VMware Partner Exchange SQL Server on VMware VBCA boot camp on...
2013-02-27
1,103 reads
We’re Live on the PowerScripting Podcast! (Thursday night, 02-28)
Your MidnightDBAs
Unusually, Sean and I will be guests on someone else’s podcast this week! Tune in live to our PowerScripting...
2013-02-27
1,273 reads
Windows 2012 for the DBA Setting Your Server to High Performance
Hello Dear Reader! I’ve been doing a lot of work with Windows Server 2012 lately. The interface is wildly different...
2013-02-27 (first published: 2013-02-20)
3,541 reads
A Month of PowerShell – Day 20 (Databases: Table-Valued Functions)
Welcome to Day 20 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-26 (first published: 2013-02-20)
2,762 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers