Compliance Ain’t Easy
I’m sure by now you’ve heard of the GDPR and some of the large scale data breaches that have occurred...
2019-03-18
341 reads
Blog Posts
Disk Space and SQL Server
One of the frequently required job functions of the database administrator is to track disk space consumption. Whether this requirement comes from management or from a learning opportunity after a...
2019-03-18
15 reads
Hugo’s SQL Server Execution Plan Reference
I’m a big fan of T-SQL Tuesday. Each month there is a host who comes up with a topic, and...
2019-03-18
453 reads
SSMS tip: Splitting the same query window
This is a trick I use in SQL Server Management Studio at least once a week.
Today’s scripts will be screenshots...
2019-03-18 (first published: 2019-03-02)
3,202 reads
The login is from an untrusted domain and cannot be used with Windows authentication
SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been...
2019-03-18 (first published: 2019-03-05)
17,057 reads
Weekly reading #7
It is MVP Summit time! I have not made it this year unfortunately. I hope all MVPs have a greate...
2019-03-18
348 reads
Why to Avoid Using the Current Database Name in Object Definitions in SQL Server
I’ve recently published an article, “Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures,” over on Simple Talk. In the article, I discuss:...
2019-03-18
17 reads
Writing a presentation 3: Entering the PowerPoint world
This is a series I’m writing as I prepare for SQL Saturday Chicago 2019. My session is called Performance tuning...
2019-03-18
326 reads
Kernel Migrator for SQL Server – Expert Product Review
Ease of use, accuracy, integrity, efficiency, and security are some characteristics which a good software should have, and when we speak of software products that focus on business users,...
2019-03-17
16 reads
Kernel Migrator for SQL Server – Expert Product Review
Ease of use, accuracy, integrity, efficiency, and security are some characteristics which a good software should have, and when we...
2019-03-17
436 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