Blogs Dennes Torres in Blogs SQL Server: Optimize for Ad Hoc Workloads – use or not use I used to believe this option was something almost absolute: it should be enabled as best practice. I was in... 06 December 2023 5 min read
Blogs Ben Johnston in Blogs SQL Server Row Level Security Deep Dive. Part 1 – Introduction and Use Cases My initial goal of documenting and exploring SQL Server Row Level Security (RLS) was to show the basic functionality and... 01 August 2023 17 min read
Blogs Louis Davidson in Blogs Generating Repeatable Sets Of Test Rows In order to test graph structures, I needed a large set of random data. In some ways, this data will... 30 September 2022 11 min read
Blogs Louis Davidson in Blogs SQL Server Graph Tables – Cross Database Surprises Louis Davidson explains how to get around an interesting issue when doing cross-database queries involving graph database tables.… 21 March 2022 3 min read
Blogs Dennes Torres in Blogs Query Store and hints: More Powerful than ever Dennes Torres explains how Query Store hints work in Azure SQL Database and Managed Instance.… 29 November 2021 6 min read
Blogs Dennes Torres in Blogs SQL Elevated Configuration: The fail-safe for maintenance Many years ago, in the company I was working for, one junior DBA started a reindex operation in a SQL... 08 November 2021 3 min read
Dennes Torres in Blogs Azure SQL: Extended Events and the use of slash “/” Many DBA skills transfer when moving to the cloud, but you'll have to make some adjustments in many cases. In... 13 September 2021 3 min read
Blogs Dennes Torres in Blogs 5 SSIS tricks you would like to know How to make conditional decisions in a package It may seems strange the lack of a decision task for the... 30 August 2021 3 min read
Database Administration Greg Larsen in Database Administration Improving performance with instant file initialization Instant file initialization can speed up database creation, file growth, and restores. Greg Larsen explains how to configure it and... 23 July 2021 12 min read
Blogs Nikhil Thakkar in Blogs Microsoft SQL Server to Oracle Database Connectivity from SSIS using Attunity Connector Almost every environment now a days need to source data from different source system. Here is how you can establish... 15 June 2021 4 min read
Database Administration Robert Sheldon in Database Administration SQL Server and hyperconvergence To be efficient and save money, many organizations are looking at hyperconverged infrastructures for SQL Server. In this article, Robert... 15 June 2021 16 min read
Robert Sheldon Simple Talk Storage 101 by Robert Sheldon The only way to derive meaning from the massive amounts of data collected today is to develop innovative high-performing, high-capacity... 10 May 2021 2 min read
Blogs Dennes Torres in Blogs Malta Data Saturday and Our New Era The Malta Data Saturday is finishing. I still need to compile the numbers, but the comments and feedback are great. Let’s... 26 April 2021 13 min read
Dennes Torres in Blogs Data Platform: Links to Study and Learn Last Friday I appeared in the middle of a Brazilian Twitch live made by a friend and while they were... 29 March 2021 4 min read
Blogs Louis Davidson in Blogs Visualizing a set of SQL Server Graph tables by generating TGF Format In my last blog, I built some Powershell to take a graph that I had modelled and bring that into... 09 February 2021 7 min read
Career Sergey Gigoyan in Career SQL Server interview questions for experienced developers SQL Server tech interview questions must be well crafted to make sure the candidate actually knows the topic. In this... 05 January 2021 16 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Heaps in SQL Server: Part 4 PFS contention When inserting rows into a heap, SQL Server must sometimes update the PFS page which can PFS contention and affect... 05 January 2021 14 min read
Blogs Dennes Torres in Blogs How to not go mad with schema compare in SSDT SSDT (SQL Server Data Tools) is really great to manage database schema changes. However, due to a disappeared feature, SSDT... 03 August 2020 2 min read
Phil Factor Temporary Tables in SQL Server Temporary tables are used by every DB developer, but they're not likely to be too adventurous with their use, or... 01 August 2020 22 min read
Roy Ernest Introduction to SQL Server Spatial Data Many applications require the handling of geospatial data. Roy and Surenda take you through the basics of SQL Server spatial... 18 March 2020 22 min read
