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, […]
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"
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 […]
You may or may not have noticed it after installing SQL Server 2012: the designer interface in Visual Studio 2010/2012 has had a make-over. Nothing too drastic, but at least the undo button works. However, sometimes when you drag or move tasks/components on the canvas, they start to shake. A lot. And very annoyingly as […]
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 […]
This month’s T-SQL Tuesday is hosted by Kenneth Fisher (blog | twitter) and its subject is about security. Security is one of those subjects that most DBAs have to deal with regardless of specialty. So as something we all have to work with at some point or another what are some tips you’d like to […]