Free Online SQL Server Training for the Week of January 12, 2013
If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...
2014-01-09
737 reads
Blog Posts
January 2014 S3OLV and Tabular Models
This is really late notice. We had some extenuating circumstances this month and then a last minute cancellation. Now that everything is squared away, we have some great news....
2014-01-09
4 reads
January 2014 S3OLV and Tabular Models
This is really late notice. We had some extenuating circumstances this month and then a last minute cancellation. Now that...
2014-01-09
656 reads
Lemonade and Life
I’ve got a torn ACL. I found out yesterday at a visit with a surgeon that gave me the results...
2014-01-09
824 reads
New Baby Girl!
On the 7th of January, 2014 my baby girl Kaitlyn was born. She came in about a month early.
This is...
2014-01-09
504 reads
Powershell in a Month – Day 8 Objects: data by another name
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-09
1,203 reads
Shutting down multiple servers with Powershell
I’ve recently helped a company move their infrastructure to a new data centre. Part of this involved shutting down a...
2014-01-09
554 reads
SQL Server – Different ways to check Recovery Model of a database
A Recovery Model is property of a database which control how transaction log is maintained. SQL Server supports SIMPLE, FULL...
2014-01-09 (first published: 2014-01-06)
2,081 reads
SSAS Dynamic KPI from a table
KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is above or...
2014-01-09 (first published: 2014-01-06)
2,606 reads
That Awkward Moment When I Started Channeling Brent Ozar
If you read my end-of-year post (you did, right?), you’ll recall that I mentioned that 2013 was a tough year...
2014-01-09
721 reads
Blogs
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...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
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