SQL Prompt is a fantastic coding aid, but it does more than format your code and provide intellisense. Over time, the team has enhanced SQL Prompt to also guide...
2020-06-01 (first published: 2020-05-18)
200 reads
Undercover Catalogue Update 0.4.3 An update to the tables module, Row count and size infotmation added Fix – LocalInterrogation There was an issue with the LocalInterrogation stored proc not...
2020-06-01
4 reads
According to the myriad of statistics used to track such things, the post “How I passed the 70-761 certification exam” has been one of the most popular on this...
2020-05-31
22 reads
In the last few posts, we were discussing about database deployment model and purchase model. Out of the three deployment models, managed instance works almost like on-premises SQL server...
2020-05-31
33 reads
Since I’ve been quarantined at home and working in my office, every day is the same. I can’t go to the gym, or coach, or go to the restaurant,...
2020-05-29
10 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-05-29
6 reads
By Steve Bolton …………Before closing out this long-delayed segment on stochastic information distances, I wanted to provide another example of how their complex interrelationships can be integrated together, to...
2020-05-29
12 reads
I’m launching a new initiative called the Community Circle Cloud Conversation Club (c5 for short). It’s going to a panel discussion lead by experts on cloud technologies. I’ll be...
2020-05-29
12 reads
Ed: SQLDork is a Junior DBA on the team here, learning the DBATools in addition to normal DBA stuff™ Today’s dbatools command is Get-DbaErrorLog, which is very similar to...
2020-05-29
4 reads
This month’s T-SQL Tuesday is hosted by my friend Glenn Berry. Glenn invites us to write about what we have been doing as a response to COVID-19. Glenn shared...
2020-05-29 (first published: 2020-05-12)
266 reads
By Steve Jones
I wrote about sequences in an editorial recently and decided to start using them....
By Steve Jones
An online conference is coming on June 17, 2020 that is full of high...
On Twitter, Michael Dyrynda writes: ?? Never ever ever ever ever ever ever ever...
Q1 -- I have read quite a few articles on page splits and am...
I am trying to monitor the sql services on couple of instances and found...
Ask SSC