Reverse Engineering Disasters
Preparing a disaster recovery plan means more than just trying to prevent a few specific disasters. It means turning around the way you view the world.
SQL Server AlwaysOn Availability Groups Fail the Initial Failover Test
The first test of AlwaysOn in SQL Server 2012 is successful, but after testing to swing back again to your primary replica, you find out that automatic failover works only the first time. How come? Carla Abanes explains.
Questions about T-SQL Expressions You Were Too Shy to Ask
Nobody seems to ask questions about SQL Expressions in forums, even though expressions can cause all sorts of problems. It's time for some straight-forward Q&As, and who better than Robert Sheldon to give the A?
Smooth Database Deployment at SQL in the City 2014
SQL in the City is coming this fall to London and Seattle.
SQL Server Service Engine fails to start after applying CU4 for SQL Server 2008 SP1
After performing an update on SQL Server, SQL Server Engine and SQL Agent stop responding.
Big Data Technologists Transition to Customer-Facing Roles
As the enterprise embraces big data, management assumes that staff sizes will decrease. What should be done with those unneeded technologists? One answer: convert them into technology consultants that collaborate and coordinate with the lines of business. In other words, give them customer-facing roles.
SQL Saturday #340 - San Diego, CA
SQL Saturday is coming to San Diego on September 20, 2014. This event has a great speaker line-up which includes Itzik Ben-Gan, Grant Fritchey, and many others. Register while space is available.
Auto Generating Multiple XML Files Using SSIS
An SSIS package that can generate an XML file for each record in an XML column in a SQL Server Database using the Source Script Component in a Data Flow Task.
Testing is Your Best Investment
One of the things that can make a big difference in how well your software performs is testing.
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
Forward Deployed Engineers
Comments posted to this topic are about the item Forward Deployed Engineers
TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage
Comments posted to this topic are about the item TRY_PARSE vs TRY_CONVERT in SQL...
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers