The risks of Delayed Durability
It’s T-SQL Tuesday again and this month we are hosted by Jens Vestergaard (b/t) who want’s us to talk about...
2016-04-18 (first published: 2016-04-12)
1,675 reads
SQLStudies
Name the schema when you create an object (or else)
This is one of those frequently ignored best practices.
When you create an object, specify the schema where it will...
2016-04-06
689 reads
Complex/Conditional ORDER BYs
Typically it’s considered best to run your queries without an ORDER BY and let the application do any sorting needed....
2016-04-04
470 reads
Hidden code in AdventureWorks
I’ve playing around with AdventureWorks and managed to found some hidden code! Truly odd stuff. I’m so shocked I couldn’t...
2016-04-01
499 reads
When should I test?
To test or not to test. That is the question. Or is it? Shouldn’t we always test? That was the...
2016-03-30
786 reads
Why you shouldn’t use SELECT *
I answered an interesting question on SE today (ever notice how many posts come from stuff I read on forums?)...
2016-03-28
505 reads
I’m presenting for the Pass Security Virtual Chapter!
Tomorrow (3/24/2016) at noon CT I’ll be presenting my SQL Server Security Basics session for the Pass Security Virtual Chapter....
2016-03-23
468 reads
TOP 1 killed my performance; Rob Farley helped me resurrect it.
tl;dr; There is no short version of this. It’s LONG. It’s interesting but you might want to skip it if...
2016-03-25 (first published: 2016-03-21)
4,621 reads
What permissions do I need?
Ever wondered how to tell what permissions are required to run a statement or perform a task? Well, sometimes it...
2016-03-16
476 reads
Pulling data from a non-clustered index
This is one of those things that I found very interesting but figured I’d probably never really use. Of course...
2016-03-14
488 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers