Do You Need A Log Recovery Tool?
A couple of weeks ago I wrote a post dispelling the myth that the simple recovery model disables the transaction...
2013-11-04
949 reads
Blog Posts
New Performance Tips eBook Out from Red Gate
Not too long ago Red Gate asked for quick tips on SQL Server performance intended for developers. I sent a...
2013-11-04
2,525 reads
Speaker of the Month, November 2013
Yeah, I’m a couple of days late. Tough. My blog. My rules.
Speaking of rules. Speaker of the Month is chosen...
2013-11-04
662 reads
SQL Server – Deploying Multiple SSIS Packages into SQL Server Using Command Prompt Utility – DTUTIL
Though there are several ways for importing SSIS packages into SQL Server either by creating a stored procedure or using...
2013-11-04
776 reads
UK SQL Relay 2013 R2 Plus Travel Info for London and Southampton
Throughout November, SQL Relay R2 2013 is taking place in the UK. This is the 2nd series of events this year. SQL Relay is a series of 1 day...
2013-11-04
10 reads
Last Weeks Top “Reading” Links #56
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-11-03
940 reads
SQL Saturday #255 Dallas 2013 - SQL Server Permissions and Security Principals
500+ IT pros at UT-Arlington this weekend for SQL Saturday #255 Dallas!
Notes from today:
A big shout-out to SQLSat Dallas organizer...
2013-11-03
714 reads
Announcing the SQLpassion Academy 2014 Course Schedule
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Time flies by,...
2013-11-02
852 reads
PASS SQL Saturday Events : November 2013
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...
2013-11-02
497 reads
PASS SQL Saturday Events : November 2013
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...
2013-11-02
613 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