A Reason To Smile! - Deep Dives II
Over this past weekend, SQL MVP Kalen Delaney sent an inspiring note to the MVP email thread, and I wanted to...
2015-01-20
1,969 reads
SQLSaturday #362 – Austin, TX – Let’s Get Weird
I used to spend the 4th of July weekend (or week) in Austin with some buddy’s when we were in...
2015-01-20
927 reads
Upgraded SSD
I was going to call this an upgraded HDD, but that’s not right. Technically it’s a drive update, but really...
2015-01-19
2,066 reads
A Healthy SQL Server
T-SQL Tuesday has come and gone and I missed the boat due to some ongoing work constraints. With that said...
2015-01-19
563 reads
Exam Prep 70-463: Data Flow Source Adapters
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-01-19
885 reads
Understand the True Source of Problems
There’s an old joke that goes, “Doctor, doctor, it hurts when I do this.” While the person in question swings...
2015-01-19
774 reads
Except and Intersect
EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in...
2015-01-23 (first published: 2015-01-19)
8,644 reads
Attending and Speaking at SQLBits XIV
The SQLBits conference has a special place in my heart – as I have written before, the previous edition of SQLBits...
2015-01-18
663 reads
SQL #57–A one-liner query with PARTITION BY
What can be done in SAS must be possible in SQL
A friend of mine is a data professional in marketing data...
2015-01-22 (first published: 2015-01-17)
10,463 reads
Hangout with Boris Hristov
A couple of days ago I had the great pleasure to join Boris Hristov in one of his awesome SQL...
2015-01-17
602 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
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 ...
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