BI Dennes Torres in BI Azure Synapse Link for SQL: From production to a data warehouse in a few clicks Microsoft announced Azure Synapse Link for SQL. In this article, MVP Dennes Torres explains the new feature.… 24 May 2022 18 min read
Editorials Kathi Kellenberger in Editorials Making predictions Steve Jones (@way0utwest), Grant Fritchey (@GFritchey), and I are often asked to predict trends in technology, especially at the end... 28 December 2021 3 min read
Database Administration Alejandro Cobar in Database Administration Using a Public Web Service to Consume SQL Server Build Numbers Keeping SQL Server instances patched can be a time-consuming task for DBAs. In this article, Alejandro Cobar explains how he... 15 June 2020 10 min read
Tools Edward Pollack in Tools Knowledge Sharing with SQL Notebooks SQL Notebooks, based on Jupyter Notebooks, is one of the best things about Azure Data Studio. In this article, Edward... 03 March 2020 16 min read
NoSQL Shel Burkow in NoSQL Translating a SQL Server Schema into a Cassandra Table: Part II Integrity Constraints Complex integrity constraints are more challenging to enforce in Cassandra than they are in a relational database. In this article,... 02 March 2020 16 min read
Books Grant Fritchey in Books SQL Server Execution Plans, Third Edition, by Grant Fritchey Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how... 04 October 2018 2 min read
Database Administration Robert Sheldon in Database Administration Adaptive Query Processing in SQL Server 2017 As new versions of SQL Server have been released, the Query Optimizer has undergone many improvements. Adaptive Query Processing, new... 01 October 2018 17 min read
Blogs Louis Davidson in Blogs A performance issue with self-referencing tables I have a great interest in hierarchy solutions, as I plan to write a book on implementing hierarchies in SQL... 27 July 2018 4 min read
Blogs Louis Davidson in Blogs Matters of Timing in Concurrency There are a few topics in SQL Server that I love academically, but are truly a pain to get right.... 31 January 2018 5 min read
Database Administration Darko Martinović in Database Administration Building a Custom Blocked Process Report Blocking in SQL Server is normal behavior, but excessive blocking can lead to many complaints and is a symptom of... 05 January 2018 31 min read
Database Administration Dennes Torres in Database Administration Extended Events Profiler (XE Profiler) in SSMS Starting in SSMS version 17.3, we have an interesting new feature: Extended Events Profiler (XE Profiler). This new feature is in... 20 October 2017 2 min read
Blogs Dennes Torres in Blogs Monitoring SQL Server with Power BI Query Store is becoming more and more important for server monitoring, specially in SQL Server 2017, which allows us to... 04 October 2017 2 min read
Dennes Torres How much should you worry about CXPACKET? Several experts already wrote about CXPACKET before, there are plenty of articles about this subject on the internet, so, why... 11 September 2017 3 min read
Database Administration Brent Ozar in Database Administration Six Scary SQL Surprises The working life of the DBA can be punctuated by surprises, but they aren't generally nice surprises. This is especially... 06 September 2017 24 min read
Blogs Dennes Torres in Blogs SQL Server 2017: New ‘Queries with high variation’ Graph A few weeks ago I published an interesting article about how to use query store to identify parameterization problems. At... 30 June 2017 3 min read
Database Administration William Brewer in Database Administration Database Cloud Backup Cribsheet Several database backup providers are now offering ‘Database Backup to the Cloud’, or ‘Backup As A Service’ (BaaS). There is... 12 September 2016 14 min read
Ben Emmett Entity Framework Performance and What You Can Do About It Without a doubt, Entity Framework is a quick and satisfactory way of producing a database-driven web application. As performance becomes... 16 December 2015 33 min read
Robert Sheldon Questions About T-SQL Transaction Isolation Levels You Were Too Shy to Ask Every time you access a relational database to make a query, you have an important decision to make: What is... 04 December 2014 28 min read
Gail Shaw SQL Server Deadlocks by Example When a SQL Server instance deadlocks, it can be anything from minor irritation to something far more severe. In this... 16 January 2014 54 min read
Rob Garrison Exploring In-memory OLTP Engine (Hekaton) in SQL Server 2014 CTP1 The continuing drop in the price of memory has made fast in-memory OLTP increasingly viable. SQL Server 2014 allows you... 25 June 2013 12 min read