Give
The world is bigger than you, and when you help others, you realize that. Making that change might also make you happier, and more successful, in your career.
Log Shipping Lite with PowerShell
A PowerShell driver that performs incremental restores on a standby server, a lite weight log shipping solution.
SQL Server CREATE TABLE syntax diagrams
Many of us have seen, on MSDN, the heading 'Syntax', followed by a rash of nested brackets and keywords, enough to put off the most resolute of code-cutters. However, there is a goldmine of information there, and Phil had an ambition to get at it, and share the gold. The result is this article, full of railroad diagrams.
xp_cmdshell for Non-System Admin Individuals
There may be times when you want to allow non-System Admin logins to be able to execute the xp_cmdshell extended stored procedure. In this articleGreg Larson will show you how to setup xp_cmdshell so non-System Admins can use this extended stored procedure.
Automating SQL Server Database Deployments: Scripting Details
To wrap up the series on Database Deployment Challenges, Alexander takes a dive into the details of how he scripted a solution and comes up with several practical tips for getting the most out of any automated database deployment framework.
Better Technical Interviews
Technical interviews don't work great, but are they dead? Is there a better way? Steve Jones comments today.
SQLServerCentral Runs sp_Blitz - Informational Items
The sixth article in our series that looks at the results of the sp_Blitz™ script run against the SQLServerCentral servers.
Export to XML Using SSIS
Exporting data to XML format using SSIS initially seems like it should be straight forward – just dump it in a flat file and give it a name xml type, however SSIS has no XML destination just an XML source. I had no luck dumping the XML in flat file. My solution was to use a script task which worked well.
Free eBook - Control Your Transaction Log so it Doesn't Control You
Download your free copy of SQL Server Transaction Log Management and see why understanding how log files work can make all the difference in a crisis.
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Half of All Engineers
Comments posted to this topic are about the item Half of All Engineers
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers