Other Phil Factor in Other Checking on the Differences Between Two Versions of a Database Build One of the common problems when you are developing databases is knowing what’s changed and when. You want to detect... 05 April 2019 10 min read
Other Louis Davidson in Other Finding a character in every character string by elimination A few weeks ago, a coworker had a scenario where he was trying to import a large amount of data... 05 April 2019 6 min read
Other Jeff Foster in Other How did we get to service meshes? If you’ve been to a conference over the last few years, you’ve probably come across microservices. A microservice architecture consists... 04 April 2019 5 min read
Other Phil Factor in Other Scripting Out a SQL Server instance (Agent jobs, XEvents, Triggers and the like) In order for a database system to work, you often need to provide programmable server objects. I’ve written very few... 25 March 2019 5 min read
Other Phil Factor in Other Scripting out several databases on a server A while ago, I wrote an article Automated Script-generation with Powershell and SMO about using SMO to script out a... 20 March 2019 4 min read
Other Kathi Kellenberger in Other Help Shape the Future of SQL Monitor Each year, Redgate runs a survey to ask the folks at companies, from DBAs and Devs to CIOs, about how... 12 March 2019 1 min read
Other Annette Allen in Other SQLBits and Data in Devon 2019 This is my first blog in a while and I’m sorry it’s not a technical one. You may be aware... 10 March 2019 2 min read
Other Louis Davidson in Other Discovering Three or Four Part Names in SQL Server Database Code I am in the middle of a project to enable our corporate databases to work with continuous integration using RedGate... 08 March 2019 6 min read
Other Louis Davidson in Other Running a .PS1 or .CMD file from Visual Studio Project Explorer Today’s blog is one of those topics that I just needed to get written down somewhere, and I expect that... 27 February 2019 3 min read
Other Dennes Torres in Other Identifying Page Information in SQL Server 2019 SQL Server 2019 has some new and very interesting functions to identify information about pages. Many operations, such as analyzing... 26 February 2019 3 min read
Other Louis Davidson in Other How To, and Not To, Escape a String In TSQL You are never too old to learn an important lesson. Like most programmers, I read programming language documentation for one... 17 February 2019 6 min read
Other Louis Davidson in Other We’re Putting the SQL Band Back Together In Chattanooga Wow, it has been a while since I last posted, with the holidays, and way too many other projects that... 14 February 2019 3 min read
Other Phil Factor in Other Using Batch Scripts, and SQLCMD to Write Out a Database’s Data. This article is about using the DOS Batch script facility of the Windows command line, together with SQLCMD to write... 12 February 2019 9 min read
Other Dennes Torres in Other 6 SSMS features that deserve some attention SSMS new versions are full of very interesting features. With SQL Server 2019 arriving, it’s normal that our focus is... 10 February 2019 5 min read
Other Phil Factor in Other Using Temporary Procedures I’ve often read in forums how people have special utility databases with all their stored procedures and functions for working... 08 February 2019 10 min read
Other Dennes Torres in Other A real parameterization problem with a plus A few weeks ago I faced this problem: One query on my application was (fortunately in the development environment) was... 12 January 2019 6 min read
Other Phil Factor in Other SQL Naming Conventions: Tables, Columns, Indexes & More SQL Server naming conventions for tables, columns, indexes, constraints, keys, and triggers. Covers identifier rules, reserved words, temporary tables, and... 09 January 2019 9 min read
Other Louis Davidson in Other The New Year Has Started, So It Must Be SQL Saturday Nashville Time! Happy New Year everyone! Hope the holiday season’s passing finds you well rested, well fed, and ready to hit the... 03 January 2019 3 min read
Other Phil Factor in Other Constraining and checking JSON Data in SQL Server Tables So you have a database with JSON in it. Can you validate it? I don’t mean just to ensure that... 17 December 2018 17 min read
Other Louis Davidson in Other Technique and Simple Utility to Determine the Datatype of a Scalar T-SQL Expression Note: post revised to take into consideration tips from comments The other day, I was working with a query where... 11 December 2018 6 min read
