Blogs Kathi Kellenberger in Blogs SQL in the City Streamed next week! I don’t know when I first heard about Redgate, but it might have been in 2005 when Steve Jones asked... 27 August 2019 1 min read
Dennes Torres OPTIMIZE_FOR_SEQUENTIAL_KEY: New 2019 feature Dennes Torres explains the 2019 option OPTIMIZE_FOR_SEQUENTIAL_KEY which can alleviate the pain of insert hotspots.… 27 August 2019 3 min read
Blogs Kathi Kellenberger in Blogs The State of SQL Server Monitoring 2019 UPDATE: Read the full report here. Recently, over 800 participants across a range of sectors and from all around the... 20 June 2019 1 min read
Blogs Phil Factor in Blogs Aggregating strings in SQL Server, using Irish Saints Days I nowadays enjoy working with front-end developers using JavaScript, especially now that SQL Server has the tools that allow the... 17 June 2019 9 min read
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
