Other Annette Allen in Other I’m speaking at SQL GLA I am one of the organisers of SQLBits and this year we decided to make some real effort with the... 07 May 2018 2 min read
Other Annette Allen in Other Who comments code? I am a firm advocate of commenting code, but you need to make sure that you are commenting the right... 05 May 2018 1 min read
Other Annette Allen in Other I’m finally blogging I have finally decided to start blogging and Redgate have kindly given me a platform to do it. So, what... 03 May 2018 2 min read
Other Louis Davidson in Other Operator Precedence versus the Confusing Constraint Translation The other day, a person I work with was creating some fairly complex CHECK constraints to protect data in a... 30 April 2018 6 min read
Other Louis Davidson in Other SQL Saturday Jacksonville – I’m Speaking! Every so often, I want to try a new location to go to, and possibly speak at, a SQL Saturday... 26 April 2018 3 min read
Other Louis Davidson in Other 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
Other Louis Davidson in Other 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
Other Louis Davidson in Other 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
Other Louis Davidson in Other 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
Other Phil Factor in Other 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
Other Krutesh Amin in Other 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
Other Ben Emmett in Other 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
Other Louis Davidson in Other 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
Other Louis Davidson in Other 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
Other Louis Davidson in Other 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
Other Louis Davidson in Other 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
Other Louis Davidson in Other 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
Other Rodney Landrum in Other 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
