Blogs Dennes Torres in Blogs Identity column vs ETL Process Creating ETL process can pose so many challenges we will only fully discover them when really building the ETL. Before... 01 March 2020 6 min read
Blogs Louis Davidson in Blogs Mixing Relational and Graph DB Objects (Book and Session Prep) Graph structures are something that I have lightly covered in my Database Design book in the last few book editions... 27 February 2020 5 min read
Blogs Phil Factor in Blogs Grappling with sp_describe_undeclared_parameters(). The Hows, Whys and Wherefores. sp_describe_undeclared_parameters() promises a great deal, but delivers less. It was added mostly for executing application queries via sp_prepare using a... 19 February 2020 8 min read
Blogs Annette Allen in Blogs Women in Tech – where are you? That’s a strange title I hear you say but it’s an honest question. I’ve worked in IT now for over... 18 February 2020 3 min read
Blogs Phil Factor in Blogs Using sys.dm_exec_describe_first_result_set_for_object. The Hows, Whys and Wherefores. I’ve been working on a project unkindly nicknamed ‘The Gloop’ because the code is a bit amorphous. Basically, it is... 17 February 2020 4 min read
Blogs Phil Factor in Blogs Copying of all data between SQL Server databases and servers This script will copy out all the tables from one version of a database in native BCP format, and place... 31 January 2020 7 min read
Blogs Louis Davidson in Blogs Speaking at Nashville SQL Saturday this weekend Boy does time fly, and it is already mid January. The holidays flew by, and now the Christmas tree and... 16 January 2020 3 min read
Blogs Dennes Torres in Blogs Power BI and Excel Power BI and Excel are tools so close to each other that Power BI was born inside Excel. Power Query,... 02 January 2020 4 min read
Blogs Annette Allen in Blogs Service Pack – Fix Missing MSI issue You know what it’s like, you are running a service pack on SQL Server and 99.9% of the time it... 11 December 2019 3 min read
Blogs Phil Factor in Blogs The Gloop: An Easier way of Managing SQL Server Documentation Here, in this blog, I’m continuing a theme that I started in a previous blog, ‘What’s in that database? Getting... 03 December 2019 11 min read
Blogs Phil Factor in Blogs 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
Blogs Phil Factor in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Dennes Torres in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Louis Davidson in Blogs 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
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
