Workload Tuning: Finding Top Offenders in SQL Server 2012
I have to give credit where credit is due. Microsoft has definitely made performance tuning easier in SQL Server 2012. Performance...
2013-08-15 (first published: 2013-08-07)
2,565 reads
Blog Posts
Be The Connector
Few things are more satisfying than to introduce two people when you think they have common interests. Often it’s driven...
2013-08-14
844 reads
Configuring BIDS 2008 / 2008 R2 and Visual Studio 2008 to work with Database & Business Intelligence Projects and Team Foundation Server (TFS)
Working with the SSIS, SSAS, and SSRS Business Intelligence projects along with Database projects in the same Visual Studio 2008...
2013-08-14
2,586 reads
Get the Backup History in your Central Management Server for SQL Server
I have a setup of Central Management Servers in my SQL Server and it’s been a big help to me...
2013-08-14
697 reads
It’s the small things that count
Sometimes it’s the small things that count.
I just noticed two small enhancements to SQL Server 2014's BOL, and I can...
2013-08-14
1,523 reads
PowerShell – Invoke Commands,Batch files & Executable file – Dynamically passing Parameters
I’ve recently got a request to invoke an executable file from Powershell. Different ways of executing a executable file is given...
2013-08-14
1,141 reads
Setting My Course for Adventure and You Can Too
I’m setting my course for a new adventure, my mind on a new … undertaking. My apologies if you thought this...
2013-08-14
932 reads
Social Media as News (and why it thrills me)
The other day I found myself in a discussion about media – print, broadcast, and social – and having to explain why...
2013-08-14
866 reads
sp_DBPermissions
Last week I posted a series of database permissions scripts. I’ve been using them quite a bit over the last...
2013-08-14
1,447 reads
Using Parameters in Power Query Extracts
Introduction
By now you have likely heard a little about Power Query (formally known as Data Explorer). While you may have...
2013-08-14 (first published: 2013-08-07)
5,071 reads
Blogs
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
By SQLPals
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...
The 2026 Redgate Summit in New York City
By Steve Jones
We’re coming back to New York, which is exciting for me. I love NYC....
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
Forums
Why SQL Server Orphaned Users Cause Login Failures
SQL Server Orphaned Users often appear after restoring or migrating a database to another...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Question of the Day
Historical Data Tracking
If I want to track historical data values, which mechanism should I use?
See possible answers