SQL Data Warehouse reference architectures
With so many product options to choose from for building a big data solution in the cloud, such as SQL...
2017-05-17
812 reads
Blog Posts
SQL Server 2016 SP1 – A significant change to licencing
A lot has been written about the change of licencing in SQL 2016 SP1. Here's my two-pence worth.
2017-05-17
17 reads
SQL Server on Docker with new Environment Variables
As of CTP 2.1 for SQL Server 2017 a set of new environment variables are available. These variables allow us...
2017-05-17
3,458 reads
TIL: Microsoft Azure Part 1
I thought maybe it would be a good idea to start a multi-part series on Today I Learned (TIL) about...
2017-05-17
532 reads
T-SQL FizzBuzz
I was looking around for something to write about this evening and came across one of Russ Thomas’ (b/t) old...
2017-05-17
2,873 reads
Update to DBCC LOGINFO in SQL Server 2017
One of the new features included in SQL Server 2017 that Microsoft has detailed here is a new DMF called...
2017-05-17
1,252 reads
Weaning yourself off of SQL Profiler (Part 2)
In a prior post, I shared a script that will take a running trace and show you the XE events...
2017-05-17
577 reads
Create a Whitelist for SQL Server - UPDATED!!!
A while back, I posted an article about creating a WhiteList for access to SQL Server. Since then I have...
2017-05-16
4,688 reads
Knowing the Options
Have you every executed a query in SQL Server Management Studio, looked at the execution plan, and noticed that it...
2017-05-16
413 reads
Migrate an SQL database from Windows to Linux using backup-and-restore and SMB Protocol
In an attempt decouple systems, we may modularize them. In most cases, we would need to move databases from one...
2017-05-16
549 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