Job & Process Documentation Tips
Three big things I look for in documentation:
Who to call when it goes wrongWhere to find it the code, especially...
2015-11-19
544 reads
Webinar Followup: Migrating your SQL Server VMs to Azure with PowerShell
Earlier this week I presented a free webinar for Pragmatic Works where I discussed how to migrate virtual machines to...
2015-11-19
1,321 reads
MVP of The Month
If you follow Grant Fritchey (B|T) at all, you know that every month he picks a “Speaker of the Month”....
2015-11-19
462 reads
The Power of Data in the Cloud
Today we had a full-day event in Microsoft about the data offerings and possibilities in the Microsoft cloud platform – Azure....
2015-11-19
711 reads
SQL New Blogger Challenge November 2015 Edition - Week 3 Digest
This week’s #sqlnewblogger posts!
Author Post @eleightondick [[T-SQL Tuesday] Data modeling: The trouble with prefixes @tomsql Adventures With TomSQL, aka Tom Staab @EdDebug [Automatically name primary key constraints in SSDT...
2015-11-19
13 reads
In-Memory OLTP Table Checkpoint Processes Performance Comparison
Checkpoint processes and other internal processes have undergone major changes for In Memory OLTP tables and transactions. The following article...
2015-11-18
690 reads
One Tool to Rule Them All – Almost
There we so many cool announcements at the PASS Summit this year, but one of my favorites was the “One...
2015-11-18
605 reads
Viewing Extended Properties for Information
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
I’ve...
2015-11-18
1,476 reads
Naught to Speaker pt 3
Becoming a speaker is one heck of a journey. Early this year I submitted a session to speak at Pass...
2015-11-18
625 reads
PowerMap with Custom Region shapefiles - Demystified
[2015-Nov-18] Today is a global GIS Day (http://www.gisday.com/) where people across the globe celebrate and promote the use of various geo...
2015-11-25 (first published: 2015-11-18)
10,615 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers