SQL Homework – December 2022 – What’s new in SQL Server?
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I ... Continue reading
2022-12-19 (first published: 2022-12-01)
447 reads
SQLStudies
Setting up my new workstation with some Chocolatey goodness.
As you might be aware I started a new job last week. Which means a new workstation and installing lots ... Continue reading
2022-11-11
175 reads
What is production grade code? : T-SQL Tuesday #156
It’s that time of the month again! It’s T-SQL Tuesday and this month Tom Zika (blog|twitter) is hosting. Tom would ... Continue reading
2022-11-23 (first published: 2022-11-08)
362 reads
SQL Homework – July 2022 – Getting ready for the next time you have to look for a job.
Back in July I suggested that you get your resume up to date. It’s something I’d wish I’d kept up ... Continue reading
2022-11-14 (first published: 2022-11-01)
253 reads
What’s next: New beginnings!
I’m both excited and frankly relieved to say that I’ve found a new position. Starting Wed Nov 2nd I’ll be ... Continue reading
2022-10-28
11 reads
What can you do with a SELECT statement without a FROM clause?
Some people have shower thoughts, I have 1am thoughts. In this case it was the only keyword required in a ... Continue reading
2022-11-07 (first published: 2022-10-25)
654 reads
Comments in your generated code : T-SQL Tuesday #155
The ever amazing Steve Jones (blog|twitter) is our host this month. And in case you didn’t know he also is ... Continue reading
2022-10-24 (first published: 2022-10-11)
302 reads
What you can do is based on more than your direct permissions.
What you have access to is not just what you have direct permissions to. The other day I needed to ... Continue reading
2022-10-19 (first published: 2022-10-06)
237 reads
SQL Homework – October 2022 – Replication part 2
In August we started taking a look at replication. We learned some of the terms used, and set up a ... Continue reading
2022-10-04
15 reads
Being a script magpie
Last month (I ran just a little bit late writing this, it was meant to go out 9/29) Brent Ozar ... Continue reading
2022-10-01
111 reads
Blogs
Get required permissions for DMVs
Part of my job at work is to update Transact-SQL reference content. System dynamic...
A New Word: Rivener
By Steve Jones
rivener – n. a chilling hint of distance that creeps slowly into a relationship...
AI and Cybersecurity: the Genie is Out of the Bottle
By Brian Kelley
Today's reality is that cybercriminals are increasingly using AI to develop better attacks. This...
Forums
2 table designs within one section to keep data for one section value within one
My requirement is to display data for a number of routes within 2 tables...
How to Resolve SQL Server Error 9100?
Is there any professional method to resolve SQL server error 9100.
Why Tech Events Matter for Data Pros (and why I’m grateful)
Comments posted to this topic are about the item Why Tech Events Matter for...
Question of the Day
New Backup Compression
What is the new software backup compression algorithm in SQL Server 2025?
See possible answers