2,560
Two Thousand Five Hundred Sixty. Seems like such a random and unassuming number, however, I can say this was the...
2012-10-23
1,444 reads
Blog Posts
Capture Index Usage Statistics for Better Analysis
Starting with SQL Server 2005, Microsoft introduced Dynamic Management Views to help DBAs see what's going inside of SQL Server....
2012-10-23
2,530 reads
I can connect to my instance locally but not remotely
Every now and again (today for example) I’ll get a call that one of our SQL Server instances is down. ...
2012-10-23
1,267 reads
Linked Server setup with Oracle
Linked Server
Setup with Oracle in SQL Server:
Suppose you want to access data from
oracle or other database products using T-SQL via...
2012-10-23
2,263 reads
Listing server and database roles for all logins and users in SQL Server – Part 3 – Using SSRS Reports to Monitor and Fix security problems
Finally the epic conclusion to my three part series about listing server and database roles. In this post I will...
2012-10-23
682 reads
Master Data Services (MDS): Miscellaneous tips
I have come across a number of tips while using MDS. These are tips not big enough for their own...
2012-10-23
9,243 reads
MDS: Copying models and data to another server
Having recently completed a model in Master Data Services (MDS), I needed to move the model from a development environment...
2012-10-23 (first published: 2012-10-16)
6,022 reads
Parallel Data Warehouse (PDW) Tip: Proof of Concept (POC) Guidelines
As with any other project our objective is to drive PDW POC success! To clear and cultivate the playing field for successful POC engagements, we must, at a minimum,...
2012-10-23
22 reads
Parallel Data Warehouse (PDW) Tip: Proof of Concept (POC) Guidelines
As with any other project our objective is to drive PDW POC success! To clear and cultivate the playing field...
2012-10-23
1,138 reads
PASS DBA Virtual Chapter Trimming Indexes, Getting Your Database in Shape
Hello Dear Reader! Tomorrow at 12 noon eastern I’ll be presenting for the PASS DBA Virtual chapter, click here to...
2012-10-23
1,024 reads
Blogs
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Forums
Backup Availability Group
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers