Folders to Check for errors in SQL Patching or Installation
Recently, while applying SQL Server 2012 Service Pack 3, encountered the following error and SQL Patch failed to upgrade.
"The patch...
2016-11-04
6,869 reads
Launching Columnstore.NET
I am so glad that the time has arrived to announce my next project – the Columnstore.NET! This site will incorporate...
2016-11-03
392 reads
PASS Summit Announcements: Power BI reports on-prem in SSRS
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set...
2016-11-03
639 reads
Reinforcing the Importance of Statistics on Row Estimate
I recently wrote an introductory post about the importance of statistics. I just received a reinforcement on how important they...
2016-11-10 (first published: 2016-11-03)
1,230 reads
Ponderings of PASS Summit 2016
Got back from Summit on Saturday and I’m still totally in the moment. I came back with so many new...
2016-11-03
429 reads
Ponderings of PASS Summit 2016
Got back from Summit on Saturday and I’m still totally in the moment. I came back with so many new...
2016-11-03
212 reads
SQL Server Backup Compression
I thought that it would be handy to capture some Perfmon graphs of what happens to backup throughput and CPU...
2016-11-03
477 reads
This Week In Data – Episode 11 (Debunking Popular Cloud Myths)
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-11-02
477 reads
Looking Back: #sqldinner at #sqlsummit 2016
Last week was the 2016 Pass Summit, and this was one of the few times that PASS did not provide...
2016-11-02
580 reads
Live 360–SQL in Orlando
I’ll be at the last big SQL Server conference in the US for 2016 this December. VS Live is a...
2016-11-10 (first published: 2016-11-02)
920 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
advice on ssrs version control
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
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
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