Write The Perfect Question (Of The Day)
Have you ever voted against something only to be glad later you got out voted? Too many years ago the...
2014-03-05 (first published: 2014-02-25)
1,495 reads
Blog Posts
Book: Expert Cube Development with SSAS Multidimensional Models
Those of you who use SQL Server Analysis Services (SSAS) are likely familiar with the “bible” for designing cubes: Expert Cube...
2014-03-04
2,323 reads
Free SQL Server Training (not a sales pitch)
My company cut the training budget this year, and it’s not that uncommon for that to happen anymore. However, I’m...
2014-03-04
1,088 reads
How Long is that SQL Command Going to Take?
Have you ever needed to restore a large database while someone is standing over your shoulder asking “How long is...
2014-03-04
3,245 reads
Mind the Gap
Recently we deployed database mirroring in an environment with an Active Directory. The process is usually quite simple and straight-forward,...
2014-03-04
637 reads
Reinstall SQL Server Performance Counters
I’ve had several instances over the last few months where I had to reinstall the SQL Server Performance Counters. It...
2014-03-04 (first published: 2014-02-25)
4,601 reads
SharePoint 2013 – Failed to install the product: D:\global\oserver.msi ErrorCode: 1603(0x643)
I often do my SharePoint setups on virtual machines since I need to build them up and tear them down...
2014-03-04
2,854 reads
SQL Intersection, Spring 2014
I am terribly jazzed to be involved with this amazing event, SQL Intersection. It’s featuring some truly amazing speakers presenting...
2014-03-04 (first published: 2014-02-26)
1,634 reads
SQL Saturday #277 Richmond – Covering new ground
SQL Saturday has been a fantastic experience for me here in the DC area (I blogged about it here) and...
2014-03-04
599 reads
Configure static or dynamic IP and DNS with Powershell
I work in a lot of different offices and conference venues, in addition to my home office. At home, I need a...
2014-03-03
877 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