Steps to install Service Pack for SQL Server 2005 – Multiple Instances
Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :-
Step 1 : First page of...
2014-07-28 (first published: 2014-07-21)
8,017 reads
Add them to ALL the roles!
I seem to get a lot of permissions questions these days and one of the more frequent ones goes along...
2014-07-28 (first published: 2014-07-21)
8,673 reads
Speaker Buddy System
SirSQL made a rather stirring post recently. He talked about a speaker buddy system to help out new speakers in...
2014-07-25 (first published: 2014-07-21)
8,027 reads
PASS Data Arch VC presents SQL Server MVP Grant Fritchey - How to Build a Database Deployment Pipeline
Please come join the Data Architecture VC this Wednesday to get info from MVP Grant about Database Deployment something all...
2014-07-21
461 reads
Clustered Columnstore Indexes – part 34 (“Deleted Segments Elimination”)
Continuation from the previous 33 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Segment Elimination for Deleted Row Groups
After some very interesting and inspiring conversations...
2014-07-20
555 reads
Extraordinary #2
This is another situation that happened on a database migration at a client site. The database migration was done by using SSIS...
2014-07-19
111 reads
Things You Can Find in the Plan Cache at SQLBits
On Saturday, I had the pleasure to present my session, “Things You Can Find in the Plan Cache”, at SQLBits!
Thanks to...
2014-07-19
455 reads
Database jokes
Sometimes when work is tough you simply need to take your eyes and mind away from your working console. Jokes are one matter that you can take a look on and smile...
2014-07-18
11 reads
Database jokes
Sometimes when work is tough you simply need to take your eyes and mind away from your working console. Jokes are one matter that you can take a look on and smile...
2014-07-18
249 reads
Database jokes
Sometimes when work is tough you simply need to take your eyes and mind away from your working console. Jokes are one...
2014-07-18
1,316 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
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...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers