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
Blogs Louis Davidson in Blogs PASS Summit Wrap-up and 2019 PASS Resolutions Most years, by the time the PASS Summit has finished, I have at least written the basics of my wrap-up... 26 November 2018 11 min read
Blogs Phil Factor in Blogs How to validate JSON Data before you import it into a database. If you are, as you should be, checking JSON data in a whole lot of files before you import them... 16 November 2018 4 min read
Blogs Phil Factor in Blogs Getting Excel Data as JSON: Rainfall and Sheep-Counting You might think that it is easy to get JSON data from a spreadsheet, and there are plenty of utilities... 14 November 2018 9 min read
Blogs Phil Factor in Blogs Setting up a simple Rest interface with SQL Server We’re going to set up a web service for a SQL Server database using node js on a windows server.... 08 November 2018 9 min read
Blogs Louis Davidson in Blogs PASS Summit Resolutions 2017 Followup The summit is my favorite time of year, but this is literally my least favorite post of every year (and... 03 November 2018 6 min read
