Presenting at SQLSaturday Tampa
The schedule just went up, I’ll be presenting PCI for the SQL DBA this year. Looking forward to visiting Tampa...
2014-02-05
504 reads
Powershell – Extract Versions for SQL Features
Over the last few months I’ve been directed to ensure that all of our SQL Servers in the Development and...
2014-02-05
1,538 reads
Book Review: The Phoenix Project
Let’s get this straight right up front, the thought of reading a novel that’s about IT is so repellent, so...
2014-02-11 (first published: 2014-02-05)
1,934 reads
Transactions: What commands aren’t allowed?
Transactions are great tools that every DBA and developer should learn how to use. Unfortunately not everything can be put...
2014-02-13 (first published: 2014-02-05)
4,566 reads
Automate T-SQL Merge For Loading Dimensions
If you’re a data warehouse developer, chances are you use T-SQL Merge statement to process slowly changing dimensions. If you’ve...
2014-02-05
1,350 reads
New Data Science – What’s Next?
While every organization is different, their “big data” is often very similar. It typically comprises massive amounts of data across...
2014-02-05
411 reads
Actual Emails: More Grief for GUIDs
Wrote this email exchange with some developer colleagues about to embark on performance tuning.
Subject: bag o' tricks from DMV talk
From: A. Developer
Hey...
2014-02-12 (first published: 2014-02-05)
2,090 reads
PowerShell – SQL Inventory – Automatic – Excel File – EMAIL
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-02-04
2,079 reads
Introducing new SQL PASS Virtual Chapter – High Availability & Disaster Recovery
Today John Sterrett (blog | twitter) and I are announcing a new SQL PASS Virtual Chapter dedicated to High Availability and Disaster...
2014-02-10 (first published: 2014-02-04)
1,397 reads
T-SQL Tuesday #051: Place Your Bets
Place Your Bets All bets on the table please. This is the last call for bets, no new bets will be allowed. This marks the 51st invitation for TSQL...
2014-02-04
7 reads
Blogs
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers