Another great reason to enable remote admin connections
I recently came cross another great reason to enable the remote admin connections server configuration on SQL server.
If you don’t...
2014-11-06
1,240 reads
Blog Posts
Configuring a Complete Memory Dump
Imagine this scenario: One of your servers just crashed, and you open a ticket with Microsoft for them to perform...
2014-11-06
1,961 reads
Drop and Recreate all Synonyms
Had a quick job the other day restoring a pair of databases under different names which is all straight forward...
2014-11-06 (first published: 2014-10-27)
18,874 reads
PASS Summit 2014 Day 2 Keynote Live Blog
We are back in the keynote room with Adam Jorgensen talking to us about the financial state and health of...
2014-11-06
412 reads
PASS Summit 2014: WIT Luncheon
Since I’m starting on the board in January, I’ve stopped taking part in the bloggers table during keynotes. First time...
2014-11-06
623 reads
PowerShell- Monitor Group Of Services on ‘N’ Servers & Notify Stopped Services
This post explains how to monitor a multiple services on a list of servers and send alert when the given...
2014-11-06
757 reads
Questions for the Board Q&A
Each year for the past few years the PASS Board of Directors has conducted a Q&A session with members at...
2014-11-06
981 reads
Summit 2014 – Early Impressions
Summit 2014 is upon us. Unless you are still under a rock, you probably know that. And if you are...
2014-11-06
583 reads
Summit 2014 – Early Impressions
Summit 2014 is upon us. Unless you are still under a rock, you probably know that. And if you are under that rock, I am curious how you are...
2014-11-06
7 reads
Using Bookmarks in SQL Server Management Studio
In SQL Server one way we optimize code is by adding indexes. Indexes help queries by essentially letting the engine know “hey, here’s the fast way to get directly...
2014-11-06
61 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