SQL Saturday Melbourne (#464) – 20 Feb 2016
For those not aware SQL Saturday is coming to Melbourne on Sat 20 Feb 2016. SQL Saturday is an excellent free learning resource for all things SQL Server – all costs are...
2016-01-18
9 reads
SQL Saturday Melbourne (#464) – 20 Feb 2016
For those not aware SQL Saturday is coming to Melbourne on Sat 20 Feb 2016.
SQL Saturday is an excellent free learning...
2016-01-18
695 reads
Disabling SQL Server Network Protocols
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-01-18
1,089 reads
Q&A: Multiple SQL Server Instances on a VM
I recently received a great question through email. It was whether or not it is a good idea to have...
2016-01-18
1,104 reads
Five Years, A Quiet Quarter, A Look Ahead to 2016
Five Years of Blogging
From to My blogging story started on December 7, 2010. I have now had a blog for...
2016-01-18
522 reads
Removing All SQL Server Query Store Data
While setting up example code for my presentation at SQL Cruise (which is going to be a fantastic event), I...
2016-01-18
539 reads
To the page and back again
To the page
It’s not one of those things you have to do frequently but every now and again you need...
2016-01-18
547 reads
Getting Started with Change Tracking in SQL Server
Change tracking for SQL Server is a flexible and easy-to-use technology for monitoring tables for inserts, updates, and deletes. In...
2016-01-18
1,084 reads
SQLSaturday Austin – Jan 30th
I will be speaking with other SQL Server experts for SQLSaturday #461 in Austin on Jan 30th, 2016. This is...
2016-01-18
475 reads
SQL From South West to Scotland : SQLSaturdays #496 & #502
I’m happy, honoured and humbled to be able to say that I will be presenting pre-cons and both SQL Saturday...
2016-01-17
402 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