SQL Training – Introduction to SQL Server Data Tools
Introduction
This document will provide a basic understanding on SQL Server Data Tools (SSDT) and its integration into Visual Studio 2012...
2013-08-07
846 reads
Blog Posts
SQLSaturday Numbers For Period Ending June 30, 2013
Just saw this in the PASS Connector:
The SQLSaturday numbers are in for our fiscal year, which ended June 30, with...
2013-08-07
653 reads
SSRS – Download all RDL files from Report Server in one go.
Introduction
People working on SSRS are well aware that “Report Manager” does not support downloading all the report files (.rdl files)...
2013-08-07
1,239 reads
SSRS: Report Actions, URL Actions and SharePoint
I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report. The child / sub-report originally had two mandatory parameters and the...
2013-08-07
38 reads
SSRS: Report Actions, URL Actions and SharePoint
I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report. The child / sub-report originally had two mandatory parameters and the...
2013-08-07
17 reads
Deadlock – A quick, easy view
Deadlocks are rough to work with. Here are the scripts I use to capture deadlocks, find which ones are reoccurring,...
2013-08-06
2,078 reads
Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 2)
SQL Server allows applications and users to execute full- text search queries against character based data in SQL Server tables....
2013-08-06
933 reads
DMV-12 : Retaion in Session & Transaction……..sys.dm_tran_session_transactions
sys.dm_tran_session_transactions DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms188739.aspx
Returns correlation information for associated transactions and sessions.
This DMV helps...
2013-08-06
1,162 reads
Ebooks From The Library–Overdrive Media Console
Recently I installed the Android version of the Overdrive Media Console on my Nexus 7. It’s a free app. Install...
2013-08-06
788 reads
Five Weeks Until SQLSaturday #232 In Orlando
Time has flown by and we’re just five weeks from SQLSaturday #232 on September 14th, 2013. It’s a time of...
2013-08-06
560 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
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...
Doing the Little Things
Comments posted to this topic are about the item Doing the Little Things
Question of the Day
Historical Data Tracking
If I want to track historical data values, which mechanism should I use?
See possible answers