T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs
T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs
This blog entry is participating in T-SQL Tuesday #024, hosted...
2011-11-08
1,794 reads
SQL Server Soldier :: News from the frontlines of the database wars
How Do I Spell #SQLFamily? #SQLNomz Of Course
How Do I Spell #SQLFamily? #SQLNomz Of Course
Nomz (Doma Kun)
It’s time for Meme Monday again, and this month’s theme is...
2011-11-07
1,183 reads
SQL PASS Summit 2011: Session Files
SQL PASS Summit 2011: Session Files
PASS Summit 2011
This past week was the SQL PASS Summit 2011 in Seattle, WA. I...
2011-10-17
1,428 reads
Presentation Files: 10 Things All BI Administrators Should Know
Presentation Files: 10 Things All BI Administrators Should Know
I sooooo remember this sign!
I was very excited to get to present...
2011-09-30
2,006 reads
The Barking Dog Analogy
The Barking Dog Analogy
Maggie and Woody
A discussion started today on Twitter about CXPacket waits. There had been a heated debate...
2011-09-20
1,104 reads
Auditing Users in a Failover Partner Database
Auditing Users in a Failover Partner Database
SQL Audit is Watching
I read a question on a discussion list today asking if...
2011-09-20
1,636 reads
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
Subject:Architecture Career Paths for SQL Server ProfessionalsLevel:200 (Intermediate)Start...
2011-09-12
910 reads
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
Subject:Architecture Career Paths for SQL Server ProfessionalsLevel:200 (Intermediate)Start...
2011-09-12
823 reads
Session Files for Replication Magic Presentation to WSSUG
Session Files for Replication Magic Presentation to WSSUG
Replication Magic
I presented my session on Replication Magic: Initializing from Backup to the...
2011-08-26
1,381 reads
August 18 Data Arch VC Meeting: John Racer on Data Warehouse Architecture
August 18 Data Arch VC Meeting: John Racer on Data Warehouse Architecture
Subject:Data Warehouse ArchitectureLevel:200 (Intermediate)Start Time:Thursday, August 18, 2011 1:00...
2011-08-15
1,398 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