Database Recovery: Day 7
Recently we were talking about Backups and how you need to test them often. The most complete way to test...
2013-12-17
642 reads
Blog Posts
Exploring Excel 2013 for BI Tip #13: Connecting Slicers in Pivot Tables Sourced from a Power Pivot Model
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-12-17
862 reads
I’m Board
No, really, I’m board. It will be officially announced today, but as of December 11th, I’m the new Director of...
2013-12-17
567 reads
Introducing Managed Backups in SQL Server 2014
Some of the new functionality of 2014 is straight forward, non-controversial and easily welcomed by the community. Think, updateable column...
2013-12-17
2,347 reads
It's Dangerous to ISNUMERIC, Take This Try_Convert
There's an issue with some characters in T-SQL when validating numeric values out of raw varchar fields, and it can...
2013-12-17 (first published: 2013-12-12)
5,752 reads
Power Query Preview December Update
Microsoft keep turning out updates to Power Query. For December, some of the new features (download):
Connection to three more data...
2013-12-17
956 reads
Powershell in a Month– Day 4 and 5 – Providers
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in...
2013-12-17
1,144 reads
SQL Server 2008 R2 Service Pack 2 Cumulative Update 10
Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 10, which is build 10.50.4297. This Cumulative Update...
2013-12-17
1,439 reads
SQL Server Diagnostic Information Queries for December 2013
I have made quite a few updates and improvements to this set of queries for December 2013. I have added...
2013-12-17
939 reads
Transactions: Rolling back a nested transaction
Transactions are great and wonderful things. They make sure that our work stays atomic, consistent, isolated and durable (yes ACID)....
2013-12-17
1,531 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