Multiple usage of functions to ensure “value” is not null? – NO
In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three...
2017-05-10 (first published: 2017-04-29)
2,398 reads
Blog Posts
My Session about SQL Server Parameterization
Last month I presented a session in the wonderful GroupBy online conference about SQL Server parameterization. The title of the...
2017-05-10
566 reads
MySQL and Backups As A Service
With today’s announcement that MySQL is available as a Platform as a Service (PaaS) offering through Azure, a lot more...
2017-05-10
607 reads
Setting Up a Subscription
In the last two blogs, we went through Configure Distribution Database and Publication Creation. If you haven’t read them, I...
2017-05-10
3,759 reads
SQL Server 2017 running on Windows Containers!
One of the questions which I normally get all the time whenever I talk about SQL Server and Docker is – Why you want to run SQL Server on...
2017-05-10
26 reads
SQL Server 2017 running on Windows Containers!
One of the questions which I normally get all the time whenever I talk about SQL Server and Docker is...
2017-05-10
2,650 reads
SQL Server Management Studio v17.0
Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server,...
2017-05-10
247 reads
Using DBCC Clonedatabase
I haven’t messed with the new DBCC CloneDatabase option in SQL Server 2014/12016 (depending on patches), but recently I saw...
2017-05-10
770 reads
Continuous Integration
It’s T-SQL Tuesday again! This month we are being hosted by James Anderson (b/t). Thanks James! He has asked us...
2017-05-09
423 reads
DBA 101: Tuning lookups
Sometimes it helps to go back to the basics and indexing is always a great topic. SQL Server has a...
2017-05-09 (first published: 2017-04-27)
3,118 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
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...
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