Unused Indexes
A sound indexing strategy is paramount to performance in an OLTP system. Not having the correct indexes in place can...
2012-11-27
2,556 reads
Blog Posts
What’s the deal with Excel & SSIS?
When it comes to importing data from an Excel sheet with SSIS, Excel has quite a reputation. And not a...
2012-11-27
1,630 reads
Can’t access Operations or Applications tabs from Central Admin WSS 3.0 SP 2
Hey Friends,
Sometime when we try to access central administration and certain tabs like operation and Application management we face issues....
2012-11-26
503 reads
Choose specific folders to sync with SkyDrive
Every time you run the SkyDrive Client on your device, a laptop in my case, all your files from the cloud are downloaded to...
2012-11-26
973 reads
Cyber Monday: Performance Indexing Book is $15
Ever thought you could learn a little bit more about indexing? Now here’s the perfect opportunity. Today only you can...
2012-11-26
821 reads
Every ebook from Apress for $15
Query Performance Tuning. Grant Fritchey. $15. If this doesn’t excite you, nothing will. Apress is offering every e-book for just $15...
2012-11-26
996 reads
Free One Week Passes to PluralSight
As you may know, SQLskills has been creating a lot of great new courses about SQL Server for Pluralsight. Nearly...
2012-11-26
1,194 reads
Last Weeks Top 10 “Reading” Links #8
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-11-26
637 reads
Migrating SQL Server Databases that use Database Master Keys
There’s a lot of things to consider when migrating databases between SQL Server instances. I want to provide some tips...
2012-11-26 (first published: 2012-11-13)
4,434 reads
Reducing the size of the distribution database & improving transactional replication performance: Part 2
The impact of having data sitting in the distribution database that doesn’t need to be there can be significant. The...
2012-11-26
4,108 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