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 […]
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"
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 […]
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 October 10th, please visit the site and sign up now! Since no SQL Saturday Minnesota would be complete without a full slate of pre-cons, […]
Microsoft is all about rapid release cycles nowadays. We already experienced this with Power BI, where monthly new features and improvements have been added. Now SQL Server appears to get the same treatment: SQL Server 2016 CTP 2.1 has just been released. There is nothing groundbreaking in this release – which can be considered as an […]
A little while back SQL Server 2016 CTP2 was announced and I have spent some time playing with it (read: spent hours creating a VM because there were hundreds of Windows updates). It seems I have already found a very small bug while creating a new database: Apparently they forgot to rename the compatibility level
I presented “Level Up Your SQL Server Index Knowledge” on Wednesday, June 10 for NEWDUG. I had a great audience that asked lot of questions and shared war stories. Presentations with lots of questions and discussion are my favorite! For those of you interested, the slides and demos can be downloaded here.
It’s my T-SQL Tuesday! I’ve spent the last year learning and teaching Extended Events – because if you really want to learn something, teach. XE can be used for everything from very simple tasks, such as counting the number of query executions, to very complicated tasks, such as anything Jonathan Kehayias writes about! I’m encouraging […]
We meet again for another edition of T-SQL Tuesday! On Tuesday, June 9, 2015, you’re invited to blog about a chosen topic. Link back to this blog post, read what others have written, and post about it on Twitter. We share knowledge and get to know other bloggers! The June 2015 topic is Extended Events. […]