Artemakis Artemiou Introducing SQL Server In-Memory OLTP In-Memory OLTP, aka Hekaton, originally shipped with 2014, and although it certainly helped the performance of certain types of workload,... 30 September 2015 10 min read
Joshua Feierman Checklists: A DBA’s Best Friend Because so much of the work of the DBA involved doing things in the right order without missing steps out,... 30 September 2015 11 min read
Adam Aspin SQLXML Bulk Loader: The Sequel SQLXML isn't exactly new technology, and parts of it aren't pretty, but if you need to heave vast quantities of... 25 September 2015 24 min read
Phil Factor Dependencies and References in SQL Server It is important for developers and DBAs to be able to determine the interdependencies of any database object. Perhaps you... 24 September 2015 20 min read
Robert Sheldon Power Query Formula Language in Power BI Desktop The Power Query Formula Language (PQFL) is a functional language that drives the Power BI transformations, and allows you to... 21 September 2015 19 min read
Uwe Ricken How Forwarded Records are Read and Processed in a SQL Server Heap Before you deliberately use a heap in SQL Server rather than a table, it is worth understanding why a heap... 09 September 2015 16 min read
Gail Shaw How to Confuse the SQL Server Query Optimizer Gail Shaw examines three common forms of generic SQL that can and will confuse the SQL Server Optimizer to the... 09 September 2015 35 min read
Dwain Camps How to Avoid Conditional JOINs in T-SQL Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within... 07 September 2015 14 min read
Kathi Kellenberger T-SQL Window Functions Speed Phreakery Before SQL Server had SQL window functions, SQL Server developers had to use all manner of tricks and algorithms to... 27 August 2015 12 min read
Robert Sheldon Working with SQL Server data in Power BI Desktop What's the best way of providing self-service business intelligence (BI) to data that is held in on-premise SQL Server? Not,... 24 August 2015 24 min read
Tony Davis Basic SQL Server Performance Troubleshooting For Developers The speed of a slow SQL Query can almost always be improved. In SQL Server, the query optimizer determines the... 14 August 2015 39 min read
Robert Sheldon The Evolution of SQL Server BI It is sometimes hard to keep up with Microsoft's direction in Business Intelligence. Over the years, we've been presented with... 27 July 2015 14 min read
Robert Sheldon How to Get NULLs Horribly Wrong in SQL Server NULLs in SQL are a mixed blessing. The Three-Valued Logic of SQL has its uses but can cause difficulties to... 25 June 2015 36 min read
Feodor Georgiev Getting to know your customers better – cohort analysis and RFM segmentation in R It often pays to use a tool like R, in conjunction with a relational database, to quickly perform a range... 12 June 2015 14 min read
Adam Aspin SQLXML Bulk Loader Basics SQLXML isn't exactly new technology, but like the even more venerable BCP, it remains the quickest and most reliable way... 02 June 2015 26 min read
Feodor Georgiev Using R to Explore Data by Analysis – for SQL Professionals What's the best way for a SQL programmer to learn about R? It's probably by trying out various experiments with... 02 June 2015 17 min read
Alex Kuznetsov Reusing T-SQL Code Database programmers are often caught in the paradox of wanting to implement business rules and complex functionality in one place... 28 May 2015 27 min read
Robert Sheldon How to Get SQL Server Dates and Times Horribly Wrong One of the times that you need things to go right is when you are doing analysis and reporting. This... 28 May 2015 35 min read
Dwain Camps Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008 Percentiles give meaning to measurements by telling you the percentage of the population being measured who get higher or lower... 18 May 2015 27 min read
Dennes Torres Optimizing Batch Process in SQL Server SQL Server batch processes are usually run from SQL Agent in background. They can take significant time and resources, especially... 08 May 2015 32 min read
