Deadlocks in a SQL Server instance are problematic. They can cause application errors, slow performance, and unhappy users. As a DBA or developer, it’s very helpful to be able to find deadlocks, review what caused them, and fix it permanently, if possible. How do you find deadlocks? Over the years, there have been various methods, […]
Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
Browsing "Data Management"
Several years ago, I launched SQLisHard to help folks learn SQL. Some folks learn well from books or videos, but others learn best by getting in there and running queries. I monitored and tweaked things for about a year, trying to get the first set of exercises smoothed out. Then, like many folks, I was […]
Have you ever wondered how you could take one or more .sql files you captured as a workload and run them against a SQL Server or Azure SQL Database to test performance or impact? Microsoft has a free tool to do just that – ostress. Ostress.exe is part of the RML utilities. The first step […]
So, you’re a developer? or an architect? or maybe even a technical delivery manager? Great 🙂 I need you! I’m currently doing some research for an upcoming book, and for a new software product, and who better to ask than those that are building and delivering software solutions each and every day? So I’d like […]
Throughout the last few years, I’ve worked with SQL Server Availability Groups, Transactional Replication, and Azure SQL Databases. Recently, I had the challenge and opportunity to work on a project that involved all three at the same time. The goal was to take six databases that were in a SQL Server 2012 Availability Group and […]
I’ll be in Las Vegas October 24-28, 2016 for SQLintersection, part of the DEVintersection conference series! Why attend DEVintersection? It “brings your favorite Microsoft leaders, engineers and industry experts together to educate, network, and share their expertise with you. Just this year, ASP.NET Core, SQL Server 2016, Visual Studio 2015, Windows 10 and SharePoint 2016 […]
I’m excited to cross the Mississippi River again this autumn to present at SQLSaturday #557 Minnesota 2016. First, I’ll be giving a full-day pre-conference session, “Get Started With SQL Server in Azure”, on Friday, September 30. Tickets are only $110, include lunch, and you’ll get to hear me talk about What you need to know about […]
Before we know it, October will be upon us and it will be time for another SQL Saturday Minnesota! If you have not yet registered for this free day of training on Saturday October 1st, please visit the site and sign up now! Since no SQL Saturday Minnesota would be complete without a full slate of pre-cons, PASSMN and the organizers of SQL […]
I’ve been blogging about SQL Server for years. Most of these blogs are designed for the database administrator or developer, and thus use SQL Server Management Studio exclusively. (Back in the day, I’d show SSRS a lot, too.) But one of the questions that’s always been at the back of my mind is, “What does […]
You: curious about Azure, wondering if it’s right for your organization. You run some SQL Server databases, but don’t know if you would use a VM in Azure, or should jump into an Azure SQL Database. You know there are some differences and complexities, but aren’t sure how to work with them. Me: ready to […]