Blogs Kathi Kellenberger in Blogs 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
Blogs Annette Allen in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Dennes Torres in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Phil Factor in Blogs 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
Blogs Dennes Torres in Blogs 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
Blogs Phil Factor in Blogs 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
Blogs Dennes Torres in Blogs 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
Blogs Phil Factor in Blogs SQL naming conventions SQL naming conventions for tables, and all the associated objects such as indexes, constraints, keys and triggers, are important for... 09 January 2019 9 min read
Blogs Louis Davidson in Blogs 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
Blogs Phil Factor in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Dennes Torres in Blogs Graph Edge Constraints and a Crystal Ball When I read the list of new features in SQL Server 2019 I became very proud of my crystal ball... 08 December 2018 2 min read
Blogs Louis Davidson in Blogs I Have an Exclusive Lock, My Row Is Safe, Right? Note: This is an update of a blog I posted in 2006 with a lot of additional information (I was... 06 December 2018 7 min read
Blogs Phil Factor in Blogs Producing Data and Schemas in JSON array-of-array format. JSON was initially designed for the informal transfer of data that has no schema. It has no concept of a... 05 December 2018 24 min read
Blogs Kathi Kellenberger in Blogs Three Books That Have Influenced My Career I’m a lifelong learner. One of the ways I love to learn is by reading books. While I was making... 03 December 2018 3 min read
Blogs Dennes Torres in Blogs New Technologies to Study One great result from PASS Summit, especially when we are close to a new SQL Server release, is to identify... 28 November 2018 7 min read
