Storage 101: The Future of Storage
Robert Sheldon wraps up his series on storage by discussing the latest storage innovation and ideas.
Automation is a Key Skill for the Modern DBA
This month's T-SQL Tuesday had lots of posts that look at automation from the DBA perspective, rather than the software developer.
Remote Work Benefits
Today Steve wonders if companies ought to support remote work better with other benefits.
Delete Duplicate Rows with No Primary Key on a SQL Server Table
Every once in awhile a table gets created without a primary key and duplicate records get entered. The problem gets even worse when you have two identical rows in the table and there is no way to distinguish between the two rows. So how do you delete the duplicate record?
When SQL Server Performance Goes Bad: Implicit Conversions
When you're developing a database, the pressure is on to get something that works, using an efficient algorithm. When you are getting close to a release candidate, however, there are some programming habits that must be removed from the code, because they can cause unexpected performance problems. In this article, you'll learn how to detect and remove one such problem: reliance on implicit datatype conversions in your queries. We'll use a combination of plan cache queries, extended events, and SQL Monitor.
SCOM Alert: MSSQL 2014: SQL Server cannot authenticate using Kerberos
Learn how to correct an error that is overloading SCOM by fixing an SPN.
The Two Ways Containers Will Revolutionize Database DevOps
Containers have already transformed the way application development works, but adoption has been slower for databases. Finally, the revolution is beginning. In this post, Kendra Little shares the two ways in which containers will dramatically change the way teams develop and deploy database changes.
Do You Have Big Data?
Data sizes are always growing. Stats on world data are astounding, as are the stats many of us experience in our lives. Plenty of us have moved from MB management to GBs, and I see plenty of people dealing with TB storage at home. Most of that data is likely from images and video, but […]
Half Of You Don’t Understand Variables and Transactions.
Do table variables and variables respect transactions? If we set the value of a variable during a transaction, and we roll it back, what happens?
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
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...
DBCC CHECKDB Limits II
Comments posted to this topic are about the item DBCC CHECKDB Limits II
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