Why you should always build an Azure based VM in a Resource Group
This blog post is based on conversations I witnessed between MVPs around commissioning and more importantly de-commissioning virtual machines (VMs)...
2018-09-26
730 reads
HeyMo0sh
How to sync user logins across SQL Server instances – dbatools is brilliant
This blog post is about how brilliant dbatools are. In this case – for syncing user logins between SQL Server instances.
Background:
Whenever...
2018-04-13
1,052 reads
How to change the TFS Agent _work folder
This blog post is about how to change the default work folder _work that TFS agents use when building a...
2018-04-10
570 reads
Use Boot Diagnostics to see what your Azure VM is doing at boot time
This blog post is about how to diagnose what your Azure VM is doing while it is booting.
I have a...
2018-04-06 (first published: 2018-04-04)
1,604 reads
Authentication issues with GitHub: An error occurred while sending the request —> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel.
This blog post is about an error that you may receive if you’re using git commands in PowerShell and authenticating...
2018-03-31
689 reads
Redgate SQL Test utility isn’t showing up in SSMS
I had recently installed the SQL Toolbelt from Redgate at a client site on a laptop they’d supplied me.
(Fantastic product...
2018-03-21
360 reads
Automation and cleaner code/data are the key to future success
This blog post is a copy of a post I wrote for SQL Masters Consulting as part of T-SQL Tuesday....
2018-03-15
246 reads
Doing DevOPs for your Database? You need to start here…
I’ve been doing that thing called DevOPs for about 17 years – you know – before it had a name…
In fact it...
2018-02-28
1,248 reads
The Data Platform has expanded – so too should our approach in using it….
In recent years we as data professionals have moved from dealing with SQL Server databases with SQL Server Reporting Server...
2018-02-26
484 reads
If your Surface Book loses it’s keyboard and trackpad – try removing KB4074588 update
My Surface Book (gen 1) recently did updates and then a day or so later the keyboard and trackpad mysteriously...
2018-02-24
440 reads
Blogs
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
The Comprehensive Guide to Mastering Your SQL DBA Skills
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
Friday Basics: Authentication vs. Authorization
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Forums
WhatsApp+19254941544 La guía definitiva para obtener una licencia de conducir en
WhatsApp+19254941544 La guía definitiva para obtener una licencia de conducir en California El Departamento...
Performance
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
Question of the Day
Two Table Hints
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers