Users: 30k; Pages Per Session: 2.5pg; Avg. Session Duration: 1:35mi
Explore Tools
{Featuring Microsoft Technologies + Enterprise Data + Cloud Computing}


February 24, 2018

Using PowerShell to spin up Windock's Docker Containers running SQL Server with Cloned Databases
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Clone Terabyte data in seconds
Read More
Tags Containers, Powershell, SQL Containers, SQLServer
February 13, 2018

Extract Blocking Chains from your SQL Servers
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Find the Head / Lead Blockers to eliminate/lower your rate of Blocking
Read More
Tags SQLServer
February 11, 2018

Hitting the 16 Terabytes Data File Limit
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Maximum Capacity Specifications for SQL Server
Read More
Tags DMVs, SQLServer, SQLServerHealthCheck, SQLServerIndexes, SQLServerPerformance, SQLServerTransactionLog
February 2, 2018

Always On: The availability replica manager is going offline because the local Windows Server Failover Clustering (WSFC) node has lost quorum.
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
SQL Server Error Log, Failover Cluster Cluster Events, Cluster.log
Read More
Tags AzureVirtualMachine, CloudComputing, SQLServer, SQLServerAlwaysOn, WindowsFailoverCluster
January 28, 2018

Using Windock's Docker SQL Containers to deliver multiple SQL Server Environment(s) in seconds on a single machine
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Automation, Continuous Integration
Read More
Tags Containers, SQL Containers, SQLServer
January 23, 2018

Using Profiler to view SQL:StmtRecompiles and the EventSubClass to see the reason for a recompile (w/ Stored Procedure using Dynamic SQL)
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.trace_events, sys.trace_subclass_values
Read More
Tags SQLServer, SQLServerProfiler, TSQL
January 22, 2018

The request limit for the database is 400 and has been reached
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Azure SQL Database resource limits
Read More
Tags AzureSQLDatabase, CloudComputing, SQLServer, SQLServerPerformance
January 19, 2018

Powershell Functions to check if TLS 1.2 updates are required
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Check if SQL Server Native Client can support TLS 1.2, Check if Microsoft ODBC Driver for SQL Server can support TLS 1.2
Read More
Tags Powershell, SQLServer
January 9, 2018

SQL Always On Monitor
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Captures, Logs, Alerts & Reports for Microsoft SQL Server Always On Availability Groups Metrics.
Read More
Tags SQLServer, SQLServerAlwaysOn
December 18, 2017

T-SQL Generate Attach or Detach All User Databases for Migration
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sp_detach_db, sp_attach_db
Read More
Tags SQLServer, TSQL
Future Events
DevIntersection 2018
Microsoft Ignite 2018
IT/Dev Connections 2018
Popular Tags
Pinned Posts
Create a Microsoft SQL Server Audit Report using Powershell
SQL Space Monitor - Version 2
T-SQL - Constants vs Parameters vs Local Variables - Execution Plans, Statistics, Assumptions
SQL Server - File IO - Sizes, Usage, Stats - Write(Insert) vs Read(Select)
Azure Virtual Machines running SQL Server 2016 STD AlwaysON Availability Groups w/ Transactional Replication
T-SQL Transform Row Data into Columns using PIVOT
List all SQL Server Reporting Services Subscriptions
Calculate RTO(Recovery Time Objective) in AlwaysON Availability Groups
T-SQL Get Maximum Value from a list of Columns Values
SQL Server 2016 Compress() & Decompress()
JSON in SQL Server 2016
Temporal Tables in SQL Server 2016
T-SQL Merge
T-SQL Pivot Data
T-SQL - Recursive CTE's

©2015; Contact us:

Website Disclaimer:, owners, authors, affiliates) is not responsible for, and expressly disclaims all liability for, damages of any kind arising out of use, reference to, or reliance on any information, products, services, graphics, videos or any content contained within the website. is not responsible for the accuracy of content provided as it is informational purposes only with no warranties and confers no rights. Any reliance you place on such content is therefore strictly at your own risk. contains links to other websites which it is not responsible for the information or privacy policies of those sites. The inclusion of any links does not necessarily imply a recommendation or endorse the views expressed within them.