Changing configuration settings with sp_configure
I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that...
2014-09-24 (first published: 2014-09-22)
7,999 reads
Blog Posts
Resolving SSDT-BI Installation with IsVisualStudio2012ProInstalled() error
Recently I was building a new virtual machine for presentations, and loaded up my usual battery – Windows 7, SQL Server...
2014-09-24 (first published: 2014-09-22)
6,478 reads
SQLSaturday Orlando Marketing Plan-Part 46
Registration count after some cancellations now at 577, way above my goal of 500. We’ve decided not to spend on...
2014-09-24
520 reads
Still time to get a SQL Server tattoo
Not for me, and perhaps not for you, but you can still encourage Jason Strate, Gareth Swanepoel, Ed Watson, and...
2014-09-24
861 reads
Thoughts on PASS Board Nomination Process: #passvotes
Having very recently gone through the nomination process for the PASS Board, I thought I would share a few things...
2014-09-24
502 reads
What I know about batch files
For a SQL Server guy it sometimes amazes me how often I’m in and out of batch files and how...
2014-09-24
625 reads
A SQLServerCentral DR Event
We had a disaster at SQLServerCentral this past weekend. It wasn’t a big disaster, but it was an event that...
2014-09-23
727 reads
Parameterization Part 5: Two Common Mistakes
This is the fifth post in my Parameterization series. In previous posts I wrote about parameter sniffing and when it is...
2014-09-23 (first published: 2014-09-20)
9,003 reads
PASS Chapter Leaders - Remember To Talk About Elections With Your Chapters!
Last week before our monthly MagicPASS meeting I went through my usual routine of grabbing the PASS chapter deck and...
2014-09-23
533 reads
SQL Server Query Performance Tuning
The latest update to my book, SQL Server Query Performance Tuning was released last week. This is the fourth edition...
2014-09-23
787 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers