Blogs Louis Davidson in Blogs Finding overlapping ranges of data This week, I had a problem where I needed to find and eliminate from the results of my query, data... 18 April 2018 15 min read
Blogs Louis Davidson in Blogs Using SQLCMD, End Execution of SQL Commands in a File This week’s blog is a just about a few simple SQLCMD mode tricks for SSMS, but these tricks have saved... 09 April 2018 6 min read
Blogs Louis Davidson in Blogs Just What Exactly Will Cast to a Bit Value? I am working through my OneNote folder of blog ideas, and this one, while being one of the least consequential... 02 April 2018 4 min read
Louis Davidson Eliminating Annoying Space Characters Via Check Constraints Along with designing databases, I do a lot of ETL from, well, let’s call them “third party systems that I... 26 March 2018 9 min read
Blogs Louis Davidson in Blogs Securing access to data for admin and dbo In this blog, I want to explore what you can do to block the owner of a database from doing... 19 March 2018 11 min read
Blogs Phil Factor in Blogs Using Stored Procedures in SQL Server that return several results. Stored Procedures give you more freedom than functions, and so they would be the obvious way of developing processes in... 07 March 2018 3 min read
Blogs Krutesh Amin in Blogs Microsoft Dynamics 365 Storage Pitfalls – Here is the Cost Effective Solution In Microsoft Dynamics 365, by default, database is optimized for database record storage and not for files or attachment storage.... 03 March 2018 10 min read
Blogs Ben Emmett in Blogs My First Experience Migrating a .NET App to Core I recently migrated an old .NET Framework 4.5.2 app to .NET Core 2.0. This isn’t a guide to that process... 26 February 2018 9 min read
Blogs Louis Davidson in Blogs Music City Data – A Conference for Data Professionals Update: the schedule is out there, and as we promised, the topics are diverse. http://www.musiccitycode.com/sessions/ The conference starts in just two weeks... 14 February 2018 3 min read
Blogs Louis Davidson in Blogs Outputting Status In Your T-SQL Code The versatility of T-SQL allows you to create complex scripts to accomplish just about anything you need to do. In... 09 February 2018 5 min read
Blogs Louis Davidson in Blogs Matters of Timing in Concurrency There are a few topics in SQL Server that I love academically, but are truly a pain to get right.... 31 January 2018 5 min read
Blogs Louis Davidson in Blogs What Counts For A DBA – Adequacy “Aim High!” “You could be president some day!” “You’re just as smart as that Einstein kid down the street” …... 26 January 2018 3 min read
Blogs Louis Davidson in Blogs Inline Index Definition There are a lot of features of SQL Server that I (and I know some of you), never really get... 18 January 2018 3 min read
Blogs Rodney Landrum in Blogs Ready Player Tattoo I am sitting in my hotel room in Nashville getting ready for #SQLSatNash as I write this. I know there... 17 January 2018 7 min read
Louis Davidson New Beginnings for an Old Blogger The pain of parting is nothing to the joy of meeting again. – Charles Dickens Happy New Year! I am... 08 January 2018 3 min read
Blogs John Paul Cook in Blogs Simulating Bad Networks to Test SQL Server Replication SQL Server replication works well on a low latency, high bandwidth network. When actual networks have high latency or limited... 02 January 2018 8 min read
Blogs Phil Factor in Blogs Pivot Rotation and Matrix Transpose in SQL Server: A New Method? The question often comes up: how do you pivot data in SQL Server? In looking closer at the question, there... 12 December 2017 7 min read
Blogs John Paul Cook in Blogs Troubleshooting Failed PolyBase Installation in SQL Server 2017 This article shows you how to troubleshoot a failed installation of SQL Server and how to implement a workaround to... 12 December 2017 4 min read
Blogs Dennes Torres in Blogs Easy way to create policies using SSMS SSMS has an interesting feature that turns easy the creation of policies to check our servers compliance. Right-clicking an item... 09 October 2017 2 min read
Blogs Dennes Torres in Blogs Monitoring SQL Server with Power BI Query Store is becoming more and more important for server monitoring, specially in SQL Server 2017, which allows us to... 04 October 2017 2 min read
