Watch this week's video on YouTube
SQL Server has several ways to store queries for later executions.
This makes developers happy because it allows them to follow DRY principles: Don't Repeat Yourself. The more...
2019-10-22
11 reads
Watch this week's video on YouTube
SQL Server has several ways to store queries for later executions.
This makes developers happy because it allows them to follow DRY principles: Don't Repeat Yourself. The more...
2019-10-22
7 reads
Our 13th SQLSaturday is done. Some quick notes about the overall event, then as time/energy allow I’ll post separately on some things that went well (or didn’t) and some...
2019-10-22
30 reads
In this month’s (October 2019) release of Power BI Desktop, they have added a ton of cool stuff, you can read all about it via the Power BI Blog. ...
2019-10-22 (first published: 2019-10-15)
413 reads
I’ve rarely thought about licensing my code, but it’s something to be aware of for your work. Most of us freely share code, though I have started to add...
2019-10-21
47 reads
So I started blogging in 2016: So why blog….now? It is very interesting going back and reading that first blog post. It was mostly thanks to my late great...
2019-10-21
25 reads
If you’ve been reading these Database Fundamentals posts, you’ve already seen the WHERE clause because of your use of it when manipulating data with DELETE and UPDATE statements. It’s...
2019-10-21 (first published: 2019-10-14)
603 reads
Years ago Redgate Software started some work to link our tools together. I remember early efforts, about which I had dubious thoughts as to the value. I hadn’t looked...
2019-10-21 (first published: 2019-10-14)
256 reads
This is the third in my series of posts which I hope will help you (and me!) prepare for the upcoming PASS Summit November 4-8, 2019 in Seattle, Washington.
So...
2019-10-21
1 reads
The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad practices for security in SQL Server. He summarizes all the most important areas you should...
2019-10-21
20 reads
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Hello, I think I need a recursive cte query but unsure of the logic....
Comments posted to this topic are about the item The Security of Old Tech
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers