Blogs Louis Davidson in Blogs A Father’s Influence My dad and I had a very interesting and complex relationship. Some of this was due to his complex upbringing.... 16 June 2019 7 min read
Louis Davidson SQL Saturday Virginia Beach this weekend! Coming up this weekend, I will be in Virginia Beach, VA for their first ever SQL Saturday event. I have... 05 June 2019 2 min read
Blogs Louis Davidson in Blogs NOT NULL Persisted Computed Columns (And What They Allow) Ok, so I have been, and will mostly stay, in a bit of blog hibernation. I am super busy trying... 01 June 2019 11 min read
Blogs Phil Factor in Blogs Scripting out SQL Server Data as Insert statements via PowerShell As a companion script with my recent article about Scripting out several databases on a server, here is a similar script that... 30 May 2019 5 min read
Blogs Phil Factor in Blogs Enjoying Joins in MongoDB MongoDB has a prodigious appetite for unstructured data and has its place in a Database Developer’s toolkit. Even with indexes... 02 May 2019 14 min read
Blogs Louis Davidson in Blogs Speaking at SQL Saturday Jacksonville on May the Fourth SQL Saturday Jacksonville this weekend! Coming up this weekend, on the least holiest, but still very awesome holiday (May the... 30 April 2019 3 min read
Blogs Arpan Sheth in Blogs Implementing a phone number based login/signup In today’s world, a user interacts with various apps/websites which require them to login or sign up via using their... 24 April 2019 5 min read
Blogs Phil Factor in Blogs Comparing SQL Server Instances: Objects by Name It is all to easy to build a database on a server and then expect it to be fully functional.... 23 April 2019 9 min read
Blogs Dennes Torres in Blogs Extract the Path from Filename in SQL While I was preparing an article, I faced the challenge to extract the path from a filename in SQL Server. It’s... 13 April 2019 2 min read
Blogs Phil Factor in Blogs Using JSON for matrices in SQL Server. From SQL Server 2017, it becomes more practical to use JSON arrays for representing and processing a matrix. SQL Server... 09 April 2019 6 min read
Blogs Phil Factor in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Jeff Foster in Blogs 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
Blogs Phil Factor in Blogs 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
Blogs Phil Factor in Blogs 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
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
