Other Phil Factor in Other What’s in that database? Getting information about routines There is a lot of information held in SQL Server metadata about your SQL Server procedures, triggers, views and functions.... 04 November 2019 18 min read
Other Phil Factor in Other Associating Data Directly with SQL Server Database Objects. It is easy to attach details and documentation to a SQL Server database using extended properties. In fact, you can... 29 October 2019 10 min read
Other Louis Davidson in Other Programmer Gear: Thin Apple Watch Band This blog is different than my normal T-SQL blogs I almost always do. But I know that I cannot be... 10 October 2019 5 min read
Other Dennes Torres in Other Merging tables in Power BI dataflows with PRO subscription Power BI dataflows is a powerful self-service ETL tool. However, some features demand the use of Power BI Premium, way... 03 October 2019 2 min read
Other Louis Davidson in Other The Case of the Vanishing Index Compression Recently, we started adding compression to some of our larger tables in our data warehouse where columnstore indexes didn’t make... 30 September 2019 7 min read
Other Louis Davidson in Other Getting back to normal after a long summer It has been a fun summer, sort of. 13 weeks ago, I had my left knee replaced to balance out... 25 September 2019 3 min read
Other Kathi Kellenberger in Other 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
Other Kathi Kellenberger in Other 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
Other Phil Factor in Other 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
Other Louis Davidson in Other 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
Other Louis Davidson in Other 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
Other Phil Factor in Other 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
Other Phil Factor in Other 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
Other Louis Davidson in Other 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
Other Arpan Sheth in Other 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
Other Phil Factor in Other 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
Other Dennes Torres in Other 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
Other Phil Factor in Other 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
