Free Friday: Training
There are a number of good sites that offer free training and free E-Books. The community around MS SQL is...
2013-11-29
1,191 reads
Blog Posts
Friday Followup For November 29, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-11-29
1,002 reads
How to Fail a Phone Screen
It’s funny to me how easy it is to fail a phone screen – both as the interviewer, and as the...
2013-11-29 (first published: 2013-11-18)
4,160 reads
Reblog: November 22 to November 28
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-11-29
1,400 reads
How to reset the SA password in SQL Server
Getting locked out of a SQL Server can happen in a number of ways. You could inherit a server that...
2013-11-28 (first published: 2013-11-21)
6,693 reads
Power BI for Office 365 video
A demonstration of Power BI for Office 365, showing you how all the various tools and technologies work together: Power...
2013-11-28 (first published: 2013-11-21)
2,070 reads
Throwback Thursday #2: Get Your Speak On!
I hope everyone is having a great Thanksgiving with their families. When you come out of that food coma I...
2013-11-28
1,109 reads
Connection pooling and the DBA
Here’s a great article that I came across while on my cookie break. The demonstration is so simple and straightforward....
2013-11-27
1,165 reads
Guest blog post at SQLAuthority – How many vCPUs are too many?
Last night my first guest blog pots over at SQLAuthority has gone live! It is the next in the “Notes...
2013-11-27 (first published: 2013-11-21)
1,397 reads
I’m A SQL Server Rockstar Blogger!
SQL Server Rockstar Blogger
I have a quick secret to share with my readers. Ever since I saw Tom Larock’s SQL Server...
2013-11-27
1,182 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