Murder Data
The Murder Accountability Project is worth a look. It’s a reminder that gathering good data is hard, but once you...
2017-04-06
499 reads
Using Pester with Get-DbaLastGoodCheckDb from dbatools
In my last post I showed Get-DbaLastGoodCheckDb from dbatools. This module is a community based project written by excellent, brilliant...
2017-04-06
541 reads
Apologies in advance
This is a quick post to apologise in advance if all my historical blog posts get republished.
Recently it appears that...
2017-04-06
330 reads
Wait Stats, Here and gone again?
Microsoft recently introduced a handy new feature to query plans: waitstats. That’s right, you can get actual runtime waitstats for...
2017-04-05
504 reads
Among Giants
Since becoming a Database Administrator I’ve always looked at Microsoft MVP’s as the giants in our field. I never once...
2017-04-05
335 reads
Normalization, The Sequel
If there’s one thing that SQL Server is really good at, it’s relationships. After all, a relational database management system...
2017-04-05
118 reads
[Video] JSON Usage and Performance in SQL Server 2016
Last night I had the privilege to present to the Ohio North SQL Server User Group about JSON in SQL Server 2016. There was a great crowd present (they...
2017-04-05
8 reads
Is There A Threat Inside?
If you’ve been involved in technology for any length of time you are aware of outside threats to your network...
2017-04-05
374 reads
What’s Next for SQL Clone?
I think SQL Clone is a useful, handy product. It’s what I’ve needed in a number of organizations, or it’s...
2017-04-05
650 reads
How do I change the increment of an identity column?
Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. No...
2017-04-05
494 reads
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers