Microsoft Azure – How to get details about azure locations using PowerShell
Hello friends, when we create any virtual machine using management portal we need to select the location for cloud service...
2017-08-23
570 reads
Blog Posts
Multi-server Script to Find Orphaned Data Files using PowerShell
In this article, we take the sledgehammer approach in searching for MDFs and then comparing them against files which are...
2017-08-23
499 reads
Preparing for Microsoft Certification Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI
Late last month Microsoft released the certification exam for Power BI, 70-778: Analyzing and Visualizing Data with Microsoft Power BI....
2017-08-23
1,063 reads
Redgate Hub LiveStream
Over at Redgate, we’ve been working on a new way to get information to you. It’s called the Redgate Hub....
2017-08-23
202 reads
Speaking at SQLSaturday #635 in Vancouver this weekend
This coming weekend, at SQLSaturday #635 in Vancouver BC, I will be presenting a brand new talk about Temporal Tables,...
2017-08-23
126 reads
The Wait Is Over – SSIS 2017 Is Here!
UPDATE: recent builds of SSDT for VS 2017 can break TFS integration. Read more about it in the blog post...
2017-08-23
1,139 reads
VMworld 2017 SQL Server Sessions
Just a reminder – our SQL Servers sessions for this year’s VMworld 2017 conference in Las Vegas are starting to fill...
2017-08-23
446 reads
VMworld 2017 SQL Server Sessions
Just a reminder – our SQL Servers sessions for this year’s VMworld 2017 conference in Las Vegas are starting to fill...
2017-08-23
131 reads
Docker images for custom SQL Server Installations
I no longer install SQL Server on my workstation, I use Docker to spin up instances as and when I...
2017-08-22
1,816 reads
How to Search and Destroy Non-SARGable Queries on Your Server
Unexpected SQL Server Performance Killers #3
Watch this week's video on YouTube
In this series I explore scenarios that hurt SQL Server performance and show you how to avoid them. Pulled...
2017-08-22
27 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
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