SQL – List All Tables, Space Usage Info & Other Details
One of the OP requested in the forum to find all table details of any database. The details which includes Number...
2014-05-01
1,085 reads
Logistics For All Day Meetings
Quick thoughts about the work required to make all day meetings run smoothly:
Suitable space with enough seating (and reasonable chairs!)Turn...
2014-05-07 (first published: 2014-05-01)
1,382 reads
Summer SQL Server & Database Events In and Around NY
Summer SQL Server & Database Events In and Around NY-
Happy May everyone!
Hope those April showers will bring us May flowers! ...
2014-05-01
2,357 reads
Stupid T-SQL Tricks – Part 1: Logarithms
Not just for math geeks, logarithms and their inverse functions (the exponentials) can have useful and often unexpected capabilities in...
2014-05-01
2,429 reads
DAX #2 – Installing AdventureWorks DW Tabular Model SQL Server 2012
OK, first thing first. We all know the famous Adventure Works multidimensional sample project. To learn the tubular mode/DAX, we...
2014-05-09 (first published: 2014-04-30)
14,333 reads
Speaking at Connections
I just got my acceptance to the DevConnections, SQLConnections in September for two sessions:
Continuous Integration for DatabasesMaintaining High Performance When...
2014-04-30
1,375 reads
SQL #53 – Keyboard shortcut Alt + F1 works now in SSMS 2012
Keyboard shortcut Alt + F1 works now
SSMS has a rich set of keyboard shortcuts that works by default. But in SSMS...
2014-04-30
6,249 reads
And I wonder, where that column is?
I wouldn't have decided to write this post if I didn't see my boss at one of my previous jobs...
2014-04-30
1,717 reads
The Cardinality Estimator in SQL Server 2014 – Going Forward and Backward
I saw a talk from Joe Sack (b | t) on the cardinality estimator (CE) in SQL Server 2014 and found...
2014-05-08 (first published: 2014-04-30)
3,528 reads
Decks & Demos Live
Hello Dear Reader! Just a quick update. I've been traveling a lot and I'm behind in posting some Decks & Demos....
2014-04-30
1,376 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