Power BI for Office 365 requirements
“Power BI” is an umbrella name for a lot of products, which I explain at Power BI first impressions (also I have...
2013-12-12 (first published: 2013-12-03)
3,479 reads
Blog Posts
SQL Saturdays: Day 4
Well, we talked about user groups... Let's talk about their big brother; SQL Saturdays. @SQLCenturion runs them here in OKC. They...
2013-12-12
472 reads
SQL Server 2012 Reporting Services Blueprints – Review
Recently Packt Publishing released the book SQL Server 2012 Reporting Services Blueprints authored by Marlon Ribunal (blog|twitter) and Mickey Stuewe...
2013-12-12
778 reads
Throwback Thursday #3: SQL Server & Disks
I hope everyone is having a good time gearing up for the holidays. Throwback Thursday is a bi-weekly blog series where...
2013-12-12
703 reads
What a DBA wants for Christmas
In the first few years of ITBookworm.com, we made sure to make up holiday lists of the most awesome gadgets...
2013-12-12
668 reads
A Full Backup Includes Everything (with a caveat)
Full database backups in SQL Server include all of the data, objects, tables, rows, functions, stored procedures, etc. If something...
2013-12-11
834 reads
Accidently Kicking a Database into the Restoring State
I learn new things all the time. This was one that actually stunned me. Huge props to Gail Shaw for...
2013-12-11 (first published: 2013-12-02)
2,375 reads
Database Snapshot failed due to disk space issue
Database snapshot is really a useful feature. As we know, Snapshot database file will keep increasing parallel to the DML...
2013-12-11
1,096 reads
DC SQLSat
This past weekend I had the opportunity to go visit Washington DC. It was the first time I got to stay in the Nation’s capitol for more than just...
2013-12-11
10 reads
DC SQLSat
This past weekend I had the opportunity to go visit Washington DC. It was the first time I got to...
2013-12-11
833 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