Azure Cloud “Fear” Busting #1 – Security
So here we go, the first installment of my cloud blog series. From my experience this concern is a common...
2017-07-26 (first published: 2017-07-12)
1,748 reads
All About SQL
SQL Server Rookie Mistakes
A quick elementary post which is my entry to this months’ T-SQL Tuesday entry hosted by a good friend SQLDoubleG...
2017-07-20 (first published: 2017-07-11)
2,564 reads
Using SQL Server Diagnostics (Preview)
I was VERY excited when I read the following tweet (below) from Bob Ward regarding SQL Server Diagnostics capability. What...
2017-06-27
588 reads
Blog Series: Azure Cloud “Fear” Busting
I have decided to do a 4-part series on Cloud “Fear Busting” scenarios. Why? Over the past few years working...
2017-06-22
405 reads
SQL Server TDE – Is TempDB Encrypted?
A really quick one today, something that made me think for a minute and I thought it might make others...
2017-06-19
678 reads
WinDbg and SQL Server Fun
I have a SQL Server that is constantly producing “dump” files (with a MDMP File type), these are named SQLDumpxxxx...
2017-06-14
628 reads
How/Why/What is DevOps?
Thanks to Grant for hosting this month’s T-SQL Tuesday found (http://www.scarydba.com/2017/06/06/t-sql-tuesday-091-databases-devops/) where it is a chance to share our DevOps...
2017-06-13
563 reads
Unable To Call Into C Compiler !?
Following on from my previous blog post I mentioned that I had to find a solution to the “unable to...
2017-06-07
432 reads
SQL Server – Service Terminated
I had a messy (another one) day, last thing I wanted was a “broken” SQL Server instance where I was...
2017-06-05
410 reads
SQL Server Memory Metrics
A very quick post for today, recently I have been working on some code to gather metrics around SQL Server...
2017-06-02
469 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers