DevOps is a buzz word with real substance behind it. In Notes from the Field #091, Stuart Ainsworth explains what DevOps means for a DBA’s daily job.
SQL SERVER – What are T-SQL Median? – Notes from the Field #090
SQL Server has no MEDIAN function. Kathi Kellenberger explains what a median is and how to calculate a T-SQL median in Notes from the Field #090.
SQL SERVER – Enhancing Reference Data in Master Data Services – Notes from the Field #089
Reeves Smith shows enhancing reference data in Master Data Services, building on data he added earlier with the MDS add-in for Excel.
SQL SERVER – Using Project Connections in SSIS – Notes from the Field #088
Connection managers are the gateway for most SSIS reads and writes. In Notes from the Field #088, Tim Mitchell explains how to use Project Connections in SSIS.
SQL SERVER – Why Haven’t You Disabled CPU Power Saving Yet?! – Notes from the Field #087
Notes from the Field #087: why you should disable CPU power saving on your SQL Server, and how this one setting can quietly slow queries.
SQL SERVER – How Do We Find Deadlocks? – Notes from the Field #086
To Find Deadlocks, I collect the graph of competing sessions and resources. The cycle distinguishes a deadlock from ordinary blocking.
SQL SERVER – Converting Standard SSMS File Results to Delimited – Notes from the Field #085
Clients sometimes send files made with Results To File in SSMS. Kevin shows how to convert standard SSMS file results to delimited data you can load.