Table Hierarchy goes CS
At the urging of a friend, this script is being updated for those that are dealing with Case Sensitivity. The...
2011-11-16
605 reads
Blog Posts
The CASE of the missing non-NULL T-SQL Error: None of the result expressions in a CASE specification can be NULL.
Recently, while doing some data scrubbing for a customer I got an interesting error in SSMS with one of my...
2011-11-16
1,888 reads
A Trio of Tools
I have talked about tools for SQL server a few times in the past. You can read some of what I wrote here and here. Since writing those last...
2011-11-15
11 reads
A Trio of Tools
I have talked about tools for SQL server a few times in the past. You can read some of what...
2011-11-15
850 reads
ColoradoSQL in November (2011)
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2011-11-15
825 reads
DBA in Space: Behind the Scenes Part 2
This is a continuation of my DBA in Space journal.
Monday & Tuesday, September 12-13, 2011
Today I make my “secret” journey to...
2011-11-15
561 reads
Going to PASS 2012!
As I have previously written about in this space, I have recently moved to House of Brick Technologies. Part of...
2011-11-15
388 reads
Last Week's DB Security Workshop @ Oracle Montreal
DB Security Workshop @ Oracle Montreal
I have
dedicated several posts on the importance of being a Data Steward, and the
consequences of not...
2011-11-15
1,743 reads
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
Subject:On beyond Zebra AdventureWorks or where...
2011-11-15
1,062 reads
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
Subject: On beyond Zebra AdventureWorks or where did I go wrong?
Level: 200 (Intermediate)
Start Time: Thursday, November 17, 2011 8:00...
2011-11-15
532 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
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
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...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers