What's New in SQL Server 2016, Community Technology Preview 3 (CTP 3.1)
What's New in SQL Server 2016
Benefits of SQL Server 2016:
Enhanced in-memory performance provides up to 30x faster transactions, more than...
2015-12-07
133 reads
Puzzled by T-SQL
Live blogging this a bit as I try things. This will update a bit, so you’ll have to read through.
Adam...
2015-12-03
1,418 reads
Run T-SQL in Parallel
Writing CLR procedures to run T-SQL concurrently is not an extremely new idea. I have seen a lot of implementations and I have written and improved it many times...
2015-12-03
9 reads
Run T-SQL in Parallel
Writing CLR procedures to run T-SQL concurrently is not an extremely new idea. I have seen a lot of implementations...
2015-12-03
2,964 reads
Speaking at SQLSaturday Nashville in January 2016
I’m starting the new year with a trip to Nashville for SQLSaturday #480 to do presentation on automating restores. New topic,...
2015-12-03
574 reads
Question of the Day: Check, Please
This one is live today, it’s about Powershell and restoring databases, based on some scripting I had been working on....
2015-12-03
559 reads
Changing Course On Learning
With all the new stuff on the Microsoft Data Platform, it’s really hard to keep up with it all. I had...
2015-12-03
502 reads
What Do You Mean There is No Current Database Backup?!?
Yet another late night/early morning tale...
The LOG backups for multiple databases on a server failed overnight (not all databases, but...
2015-12-03
973 reads
Atlanta BI Edition SQL Saturday Precon
The explosion of Business Intelligence (BI) capabilities coming from Microsoft these days have left many of us in a frenzy. ...
2015-12-03
909 reads
Goodness-of-Fit Testing with SQL Server, part 3.1: Skewness, Kurtosis and the Jarque-Bera Test
By Steve Bolton
…………In the last installment of this series of amateur self-tutorials on using SQL Server to identify probability distributions,...
2015-12-02
1,676 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