Fix WHERE clause AND/OR/NOT confusion with truth tables
The ANDs, ORs, and NOTs in a T-SQL query's WHERE clause can get confusing, especially if you're thinking of it...
2018-04-17
2,050 reads
SQL Awesomesauce
When was my last backup / CheckDB / index maintenance?
Keep a good eye on your backup and maintenance; they’re kind of important to the health and well-being of your job wait I mean...
2018-04-06
383 reads
Code that writes code
Code that writes code it one of the best productivity tips I can give you. And no, I’m not talking...
2018-03-30
557 reads
“The report server Web Portal URLs and Web Service URLs don’t match”
A client recently upgraded a server, and then started receiving this error when they tried to access the SSRS Reports...
2018-03-19
1,127 reads
Management Studio Shortcut – Change Connection
Update: Now with Object Explorer shortcuts! One of the most common things I do within SSMS is to change connection for...
2018-03-14
516 reads
SQL Saturday Colorado Springs, and a full-day class with the MidnightDBAs!
Edit: Now with discount code! We’ll be speaking at SQL Saturday Colorado Springs on Saturday March 24. The day before that, we...
2018-03-13
349 reads
SQL Server logins, users, SIDs, and orphaned users – a quick primer
Here’s a good starter article on SQL Server logins, users, and SIDs: SQL Server Logins, Users and Security Identifiers (SIDs) Some...
2018-03-07
481 reads
How to make a Database Request
You need something from the database admin. Maybe it’s permissions, maybe it’s code troubleshooting, or maybe it’s just that the database is...
2018-02-27
518 reads
CROSS JOIN for fun
My son, who wishes to be known as “Pigeon” for the duration of this blog, was mixing the names of Hogwarts...
2018-02-17
1,119 reads
Where on Earth is the SQL Server Reporting Services Config Manager?
While we’re on the topic of SQL Server Reporting Services: WHYYYYYY is the Reporting Service Configuration Manager so hard to...
2018-02-07
453 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...
Kantor Batik Air Surabaya | Telp.08557033334
Hub Admin Batik Air Telp/wa 08557033334 Jl. Jaksa Agung Suprapto No.5, RT.002/RW.08, Ketabang, Kec....
Kantor Batik Air Yogyakarta | Telp.08557033334
Hub Admin Batik Air Telp/wa 08557033334 Jl. Laksda Adi Sutjipto Km. 7, Flyover, Janti,...
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