Reblog: April 11 to April 17
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-04-18
516 reads
Creating Power Map Reporting Solutions Recording and Q&A
I hope you were able to attend my free webinar on Creating Power Map Reporting Solutions on April 17 2014. If you...
2014-04-18
1,031 reads
SQL Server Diagnostic Information Queries for April 2014
I made some small improvements to a few of the queries this month. I plan to add several more SQL...
2014-04-28 (first published: 2014-04-18)
4,362 reads
Speaking at SQL Bits XII
I’m heading back to SQL Bits for the third time and I’m excited to be going again. I think that...
2014-04-18
659 reads
Upcoming Presentations in May
Next month, I’ll be making a couple of stops at SQL Saturday events in the south. On May 3, I’ll...
2014-04-18
779 reads
Friday Followup For April 18, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-04-18
443 reads
MDS: A Database Error Has Occurred
I recently came across the following error message when I tried to look at the batches in the Integration Management...
2014-04-18
1,603 reads
Bringing Power BI Q&A to your Organization Recording and Q&A
I hope you were able to attend my free webinar on Bringing Power BI Q&A to your Organization on April 15...
2014-04-17
975 reads
What is the Microsoft Analytics Platform System (APS)?
Analytics Platform System (APS) is simply a renaming of the Parallel Data Warehouse (PDW). It is not really a new...
2014-04-17
1,330 reads
Why does my Failover Cluster Instance Keep Failing Back and Forth?
A few months ago I was paged by a client because their SQL Server Failover Cluster Instance (FCI) was experiencing...
2014-04-25 (first published: 2014-04-17)
8,228 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