InfoWorld Review: SQL Server 2014, by Sean McCown
InfoWorld Magazine (http://www.InfoWorld.com) has published a new article by MidnightSQL owner Sean McCown, “Review: SQL Server 2014 pushes the pedal...
2014-03-20
718 reads
Blog Posts
Meetings In Glass Houses
If you’ve followed my writing for a while you’ll know I’m a fan of translucency (transparency) in most things business....
2014-03-20
524 reads
SQL Server 2014 released April 1st!
SQL Server 2014 has been released to manufacturers (RTM) and will be generally available April 1. Here is the official...
2014-03-20
1,129 reads
Using Configuration Files in SSIS
Now in SQL 2012 we have parameters that make it easy, but configuration files are still an option and I...
2014-03-20 (first published: 2014-03-17)
3,477 reads
Virtual Lab – New Domain User
This is part of my series on building a virtual lab for use with SQL Server and Windows. You can...
2014-03-20
1,084 reads
A Nicely Made Smoke Detector
This may not be the exact model, but I bought 2 First Alert detectors at Costco for $23. Not a...
2014-03-19
672 reads
Collation: Definition
I had a recent run in with collation problems and it got me started reading. As I read I started...
2014-03-19
2,222 reads
My Favorite Free Scripts
SQL Server Maintenance Solution
I'll start off with Ola Hallengren's scripts. I'm not a fan of reinventing the wheel. If someone...
2014-03-19 (first published: 2014-03-17)
4,590 reads
Query Tuning Near You
It really is so much easier to just throw hardware at badly performing databases. Just buy a bigger, faster server...
2014-03-19
1,190 reads
Submitting PASS Summit Sessions
I’ve been thinking for a while about what to submit for this year. I knew I wanted to have one...
2014-03-19
634 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