SQLBits Review
I promised a recap/review on my first SQLBits event so I finally got around to it, hopefully you will find...
2017-04-26
500 reads
All About SQL
Redgate: SQL Search
I seriously finding searching for objects within SQL Server Management Studio (SSMS) via object explorer slow, manual and fiddly especially...
2017-04-25
457 reads
I Escaped from a SQL Server Service Pack Nightmare
I hope you take backups or have a recovery plan in place before a SQL Server service pack upgrade, if...
2017-04-24
363 reads
Getting intimate with Brent Ozar (The First Responder Kit)
Imagine this scenario, you are a database professional at your place of business and you look after a mountain of SQL...
2017-04-12
520 reads
Microsoft Data Platform is changing – so am I
This month’s T-SQL Tuesday entry hosted by Koen Verbeeck (http://sqlkover.com/t-sql-tuesday-89-invitation-the-times-they-are-a-changing/), a blog post about how we feel about the ever...
2017-04-11
324 reads
Azure: SQL Database Elastic Pool and using Elastic Jobs
I want to show you how I went from having multiple single SQL databases in Azure to a database elastic...
2017-04-04
589 reads
SQL Server DBCC CHECKDB
A quick video clip where I show two things. Firstly I show how since SQL Server 2014 SP1+ the snapshot...
2017-04-01
378 reads
Azure – SQL Database Premium RS
A very quick post for today, I was navigating my way through the Azure portal within my SQL databases section...
2017-03-28
993 reads
SQLBits 2017
I have never been to SQLBits (https://sqlbits.com/) before (due to budgets) but I am really looking forward to attending which...
2017-03-27
310 reads
Why did my SQL Server database just go offline?
Note: This post contains a video clip where I show quirky behaviour of the scripted offline task. Personally I rarely...
2017-03-24
386 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