Code I’d Hate To Live Without: T-SQL Tuesday #104
It’s TSQL Tuesday again! This time our respected host is Bert Wagner (b/t). Quick aside, if you haven’t seen his...
2018-07-19 (first published: 2018-07-10)
3,649 reads
Kenneth Fisher
Counting NULLs
Recently I was doing one of Kendra Little’s (b/t) SQL Server quizzes. Specifically the Quiz: COUNT() in SQL Server. As...
2018-07-16
1,106 reads
SQL Homework – July 2018 – Create a SQL Agent Job
For this month’s homework let’s try something a bit different. SQL Agent jobs are a very powerful tool frequently used...
2018-07-13 (first published: 2018-07-02)
2,020 reads
Stairway to AlwaysOn Crossword
This crossword puzzle is based on the contents of the Stairway to AlwaysOn.
2018-07-11
220 reads
SQL Puzzle – FizzBuzz3d
I thought for the end of the month it would be fun to do another T-SQL Puzzle. In this case...
2018-07-04 (first published: 2018-06-27)
2,178 reads
Strings vs Identifiers
A common mistake, and one I make frequently myself is to use a string in place of an identifier, or...
2018-07-02 (first published: 2018-06-20)
3,417 reads
Be our guest, be our guest, put our database to the test.
When I think of the public role I often think of the guest database principal (user) at the same time....
2018-06-25
304 reads
Moving to Azure: A change in processes – TSQL Tuesday 103
For this month’s t-sql Tuesday our host Bjoern Peters (b/t) wants us to describe our experiences with Azure SQL Database...
2018-06-22 (first published: 2018-06-12)
2,405 reads
Misleading errors: “Server is configured for Windows authentication only.” But it’s not!
In general, the errors SQL gives are highly useful. Of course every now and again you get one that’s just...
2018-06-18
805 reads
An interview with Brent Ozar
I was talking about interviews (although not the job kind) with a friend and it reminded me of the time...
2018-06-15 (first published: 2018-05-30)
2,961 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers