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 […]
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"
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 […]
Here in the Frozen Tundra of Wisconsin, winter is setting in – this weekend, temperatures didn’t rise above freezing, and snow fell in some parts of the state. I have my cold-weather running gear out – fleece-lined tights, wind-proof jacket, hats, mittens, and trail shoes – and my snowshoes are hanging in the garage. For […]
One of the benefits of Microsoft SQL Azure over an on-premises or VM installation is built-in resiliency. In a typical on-premises/VM installation your database lives on a single server, with all the single points of failure that brings to mind. SQL Azure, on the other hand, always has 3 or more replicas assigned for each […]