tSQLt tests for Day 5 Advent of Code 2017
This is day 5 of the Advent of Code 2017. If you want to read about the puzzles, start with...
2018-01-24
813 reads
Blog Posts
Using Bookmarks to navigate code in SSMS (Day 24)
Bookmarks are used in SSMS to have SSMS remember selected line positions, and to quickly move between the bookmarks. All...
2018-01-24
1,457 reads
Using Bookmarks to navigate code in SSMS (Day 24)
Bookmarks are used in SSMS to have SSMS remember selected line positions, and to quickly move between the bookmarks. All...
2018-01-24
360 reads
AWS EC2 Linux AMI with pyodbc
AWS EC2 Linux AMI with pyodbc, psqlODBC, Microsoft ODBC Drivers Context: Using pyodbc within a small python application to pull tracking data from an Azure SQL Server DB, do...
2018-01-23
85 reads
How to run a PowerShell script file with Verbose, Confirm or WhatIf
Before you run a PowerShell command that makes a change to something you should check that it is going to...
2018-01-23
1,030 reads
Implementing Smart Differential Backups Using Ola Hallengren’s Backup Scripts in SQL Server 2017
This is part 2 of 2 on taking smart backups. I wrote a previous blog on how to use configuration...
2018-01-23
145 reads
Inverted Polygons? How to Troubleshoot SQL Server’s Left Hand Rule
Last week we looked at how easy it is to import GeoJSON data into SQL Server’s geography datatype.
Sometimes your source...
2018-01-23
447 reads
Inverted Polygons? How to Troubleshoot SQL Server's Left Hand Rule
Last week we looked at how easy it is to import GeoJSON data into SQL Server's geography datatype.
Sometimes your source data won't be perfectly formatted for SQL Server's spatial...
2018-01-23
15 reads
Power BI Custom Visuals Class (Module 85 – Image Grid)
In this module you will learn how to use the Image Grid Custom Visual. This visual is a unique way...
2018-01-23 (first published: 2018-01-12)
1,890 reads
Quick Editing Tips (Day 23)
There are many editing items in SSMS that makes formatting and navigating your code easier than ever. Most of these...
2018-01-23
189 reads
Blogs
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
What Does It Mean to Make Data AI-Ready?
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
Forums
Hyperscale Replicas II
Comments posted to this topic are about the item Hyperscale Replicas II
Practical Reporting Queries with CROSS APPLY (Part 3)
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Your Favorite Quotes
Comments posted to this topic are about the item Your Favorite Quotes
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers