Pester for Presentations – Ensuring it goes ok
Whilst I was at PSCONFEU I presented a session on writing pester tests instead of using checklists. You can see it here
During the...
2017-05-16
702 reads
Blog Posts
Power BI Custom Visuals Class (Module 49 – SandDance)
In this module you will learn how to use the SandDance Power BI Custom Visual. The SandDance visual is an...
2017-05-16 (first published: 2017-05-01)
2,363 reads
Query Store Questions From The Field
I have had several Query Store questions come in from customers lately. Some of the questions stemmed from things read...
2017-05-16
97 reads
Query Store Questions From The Field
I have had several Query Store questions come in from customers lately. Some of the questions stemmed from things read...
2017-05-16
383 reads
SQL Server Clustered & NonClustered Indexes Explained
When using row level indexes there are two types Clustered and NonClustered both of which are there to make data...
2017-05-16
100 reads
SQL Server on VMware Workshop at VMworld US 2017
I am extremely proud to announce that we’re holding the second SQL Server workshop at this year’s VMworld US in Last Vegas on...
2017-05-16
378 reads
Trace Flag 1117 Growth and Contention
In this video I talk about Trace Flag 1117 and how it was designed to help keep data file growth...
2017-05-16 (first published: 2017-05-05)
1,340 reads
T-SQL Tuesday #90 Shipping Database Changes – Wrap Up
I’d like to say a huge thank you to everyone who read or published a post for T-SQL Tuesday #90....
2017-05-16
426 reads
What Do You Do When Performance Sucks?
So you are a SQL Server DBA, and you are responsible for a database, which gives you a hard time....
2017-05-16
576 reads
XML vs JSON Shootout: Which is Superior in SQL Server 2016?
Watch this week's video on YouTube
Additional performance comparisons available in an updated post.
Starting with the 2016 release, SQL Server offers native JSON support. Although the implementation is not perfect,...
2017-05-16
34 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