PASS Summit 2013 - Examples Package
I was asked by some attendees of my PASS 2013 Session, Unseen Minions : Improving parallel processing in SSIS, if I had any...
2013-10-22
455 reads
Blog Posts
PASS Summit 2013-The Entire List of Posts
This year I went with numbers instead of “Monday” or “Day 1”. I think I like it better. Easier to...
2013-10-22
696 reads
Quick note: Redgate SQL Data Compare using the command line
I’ve been working on an automated data compare process for one client. I’ve been struggling a little with odd hangups...
2013-10-22
1,148 reads
Recording Audio of Meetings
As a consultant I am often starting from the ground floor on a new data warehouse/business intelligence project, and usually...
2013-10-22
771 reads
SQL in the City, US Tour 2013, Recap
Red Gate visited three cities this year with our SQL in the City event; Pasadena, Atlanta and Charlotte. I just...
2013-10-22
840 reads
SQL Server Configuration Manager (sqlserverManager11.msc) Hidden after Windows 8.1 Upgrade
You may have noticed, like I did, that after upgrading-in-place from Windows 8 Enterprise to Windows 8.1 Enterprise, my local...
2013-10-22
7,265 reads
Why I’m Excited About Hekaton
I recently readMicrosoft’s research paper on Hekaton, the new in-memory database engine in SQL Server 2014. When I first heard...
2013-10-22
2,346 reads
Windows 8.1 Upgrade Deletes VirtualBox Host-Only Network Adapter
Windows 8.1 was released to the Windows Store last week and aside from having to download the same 3.9 GB...
2013-10-22
1,211 reads
Last Weeks Top “Reading” Links #54
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-10-21
865 reads
MSDB– cleanup is necessary
Recently I have been asked to work on the task which is to reduce the size of MSDB database. The...
2013-10-21
981 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