PASS SQLSaturday Events: April 2014
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...
2014-03-15
619 reads
Blog Posts
When Good BI Goes Bad – Data Quality
Regardless of the Technology BI is about Data
Many BI projects are sold as a technology solution. Vendors come in a...
2014-03-15
1,097 reads
Friday Followup For March 14, 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-03-14
445 reads
Introduction to Power BI Recording and Q&A
I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on March 13, 2014. If...
2014-03-14
846 reads
Reblog: March 7 to March 13
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-03-14
853 reads
SQL for Everybody
I read a terribly excited blog this morning by a guy who had just discovered Alt-F1 in SSMS. (If you don’t...
2014-03-14
642 reads
Ten Years and Counting …
On March 8, 2014, I reached ten years of service at Magenic Technologies. When I started in 1999 (don’t do...
2014-03-14
818 reads
Uniquifiers: all rows or the duplicate keys only?
Some days ago I was talking with my friend Davide Mauri about the uniquifier that SQL Server adds to clustered...
2014-03-14
910 reads
Virtual SQL Playground Adventure: Building The Virtual Environment
Few blog posts ago, I decided to build a virtual environment for a personal SQL Server sandbox. So, the Virtual...
2014-03-14 (first published: 2014-03-03)
3,677 reads
:CONNECT in SSMS
Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from...
2014-03-13
1,453 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