Automated Permissions Auditing With Powershell and T-SQL: Part 2
In Part 1 of this series, I presented a T-SQL query that will return a summary of login permissions within...
2013-11-13
574 reads
Blog Posts
Can't We All Just Get Along?: Personal Development
This isn't a normal post. This one is directed to newer people, those who feel pushed around a bit at...
2013-11-13
396 reads
Create ETL solutions faster with metadata driven development – Session Materials
Last week was the 2013 edition of the SQL Server Days. It was an amazing event: there was a great...
2013-11-13
665 reads
Create ETL solutions faster with metadata driven development – Session Materials
Last week was the 2013 edition of the SQL Server Days. It was an amazing event: there was a great...
2013-11-13
1,157 reads
Moving your FTData files and FDLAUNCHERRORLOG in Clustered SQL Server 2008
Scenario: I have given a new storage by SAN team to move my database files and logs from old drive...
2013-11-13
1,500 reads
Potential Backup Software Issues with Read-Only Databases in FULL Recovery
If you decide to park a database in read-only mode for a long period of time, go ahead and alter...
2013-11-13 (first published: 2013-11-05)
2,031 reads
Powershell in a month – Day 1
I got started on Learn Windows Powershell 3 in a Month of Lunches at lunch one day. Working at home...
2013-11-13
1,841 reads
T-SQL Tuesday #48 – My take on the cloud
So here it is, the second Tuesday of the month. This means that it is time for our favorite Tuesday...
2013-11-13
628 reads
Who’s on call
Every morning we have a daily meeting and my manager asks who’s on call. And every morning some form of...
2013-11-13
594 reads
Cargo Cult Data Professionals
Ever since David Moutray introduced me to the concept of cargo cult programming, it’s been running round and round in...
2013-11-12
984 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