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 of the year. This year... 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 created a service in Azure... 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 Pollack explains how to get... 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, Shel Burkow walks through four... 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 to read and interpret execution... 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 in 2017, represents a 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 Server in the next year... 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. The other is security, and... 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 poor performance. SQL Server contains... 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 a very early stage, but... 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 get historical information about wait... 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 one more? I think I... 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 true if the DBA is... 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 that point I hadn’t played... 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 little consensus within the industry... 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 more important, it does, however,... 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 the appropriate isolation level for... 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 article, Gail Shaw looks at... 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 to migrate the most-used tables... 25 June 2013 12 min read