Advent of Code – Day 3
Continuing with the language-independent code challenge on Advent of Code – Day 3, I’m tasked with figuring out how well a...
2015-12-24
513 reads
Thoughts on Advent of Code
Over the past couple of days I’ve posted several times about the Advent of Code Contest and worked my way through...
2015-12-24
720 reads
SQL Server 2016 AlwaysOn Availablility Enhancements
In this Article I have listed out SQL Server 2016 AlwaysOn Availability Enhancements.SQL Server 2016 [CTP 3.2] SQL Server 2016 CTP Standard Edition...
2015-12-24
456 reads
Specifying Paths to External Items (Report Builder and SSRS) in SharePoint with PowerShell
[2015-Dec-24] My story: two SSRS items (main report and its sub-report) need to be deployed to SharePoint. Trivial task, and...
2015-12-24
1,781 reads
Advent of Code #3 – Part 2
Adding to my solution for #3 part 2, I finally got it, but I paid the price for not adding...
2015-12-23
707 reads
Advent of Code #3 – Part 1
Part 1 isn’t bad. Parse a string that has direction indicators and track each location you stop at. I’m trying...
2015-12-23
1,012 reads
Advent of Code #2
This one gives you a 1000 rows of package dimensions. You calculate the surface area needed for wrapping paper, plus...
2015-12-23
673 reads
Back to Basics: Why not parameterize?
I think sometimes those of us that have been doing database administration/development for a while take it for granted that...
2015-12-23
265 reads
CISL Roadmap
The year 2015 is coming to an end and I wanted to publish my currently planned roadmap for the CISL...
2015-12-23
441 reads
Advent of Code
If you want your skills to be sharp, you practice. If you want to get yourself to actually do practice, you call it a “challenge”. This is what the...
2015-12-23
26 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