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 […]
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 "Database Programming"
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 […]
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. […]
For those who haven’t noticed already: SQL Server 2016 CTP2 (or Preview as some call it) has just been released! This means it is play time! You can either download a copy if you’re old school like me, or you can spin up a VM in Azure like all the cool kids. SQL Server 2016 […]
That’s right! I will solve a performance issue by adding a UNION into the query. Interested? Read on! I recently encountered a curious issue with a query. The query itself wasn’t exactly rocket science: it read data from a few tables and calculated the start and the end dates of a contract in the SELECT […]