Toolbox - Just the Basics
There are many query sets out there to collect varying groups of configuration data - the ones I most frequently use...
2018-03-29
689 reads
There are many query sets out there to collect varying groups of configuration data - the ones I most frequently use...
2018-03-29
689 reads
One of the most important parts of continuing learning as a DBA (or probably an IT Professional) is reading blogs. ...
2018-03-07
368 reads
One of the joys of working with SQL Server is the descriptive and meaningful error messages, right?
https://vignette.wikia.nocookie.net/batmantheanimatedseries/images/a/a7/DiD_39_-_Joker_Vision.jpg/revision/latest?cb=20160610021326
Exhibit A - the 33206:
Error:...
2018-03-13 (first published: 2018-03-05)
15,584 reads
A few years ago I wrote what would turn out to be my most-hit blog post (so far) titled "Error...
2018-02-07
384 reads
I have written previously (here)about how to tell which database files have free space in them when your drive starts...
2018-01-19
3,691 reads
https://media.makeameme.org/created/mega-bytes-well.jpgIt's T-SQL Tuesday time again - the monthly blog party was started by Adam Machanic (blog/@AdamMachanic) and each month someone different...
2018-01-09
544 reads
Tomorrow 12/09/2017 is SQL Saturday #694 in Providence, RI.
I will be presenting by SQL Server Health Check session first thing...
2017-12-08
356 reads
UPDATE - the feed and schedule are live at http://www.pass.org/summit/2017/PASStv.aspx
http://rochistory.com/blog/wp-content/uploads/2014/09/NBC-logo.pngNot in Seattle for some reason this week? Like maybe you stayed home...
2017-11-01
434 reads
Do you like Log Shipping?
Before my time at Ntirety I had done quite a bit of work with failover clustering...
2017-11-02 (first published: 2017-10-23)
3,223 reads
https://memegenerator.net/img/instances/400x/59507872/you-get-a-deadlock-everybody-gets-a-deadlock.jpgWe all get them at one point or another - deadlocks.
I have Object 1 and need Object 2, you have Object...
2017-10-26 (first published: 2017-10-18)
3,554 reads
By Steve Jones
tangency– n. a fleeting glimpse of what might have been. I tend to live...
I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...
The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...
I'm struggling setting relationships among tables. I understand the one-to-many, many-to-one, many-to-many, and self-referential...
Hi All, need help with an SQL query. We have an existing table that's...
I connect to this clustered instance and run : begin distributed transaction Msg 8501,...
What is the output of this code in SQL Server 2022?
select bit_count(0xEF)See possible answers