Joshua Feierman The Enterprise DBA Mindset as a Practical Problem-solving Approach In order to keep the demands of the job under control, any DBA needs to automate as many as possible... 10 May 2016 13 min read
Murilo Miranda In-Memory OLTP – Row Structure and Indexes There are several decisions to be made when designing indexes for Memory-optimized tables in In-Memory OLTP, and to make the... 04 May 2016 12 min read
Murilo Miranda In-Memory OLTP – Understanding Memory-Optimized Tables How do you get started with In-memory OLTP? Murilo Miranda first advises on the setup of the server and the... 04 May 2016 13 min read
Phil Factor Automatically Creating UML Database Diagrams for SQL Server SQL Server database developers seem reluctant to use diagrams when documenting their databases. It is probably because it has, in... 03 May 2016 20 min read
Database Administration Feodor Georgiev in Database Administration SQL Server Security Audit Basics SQL Server Server Audit has grown in functionality over the years but it can be tricky to maintain and use... 18 April 2016 17 min read
Enrico van de Laar The SQL Server 2016 Query Store: Analyzing Query Store Performance There are some obvious advantages to having the Query Store, but what is the performance impact that it is likely... 13 April 2016 8 min read
Artemakis Artemiou Implementing SQL Server In-Memory OLTP How do you go about transferring a disk-based workload to the respective memory-optimized design? How do you process memory-optimized tables?... 11 April 2016 12 min read
Robert Sheldon SQL Server System Functions: The Basics Every SQL Server Database programmer needs to be familiar with the System Functions. These range from the sublime (such as... 31 March 2016 22 min read
Kathi Kellenberger T-SQL Window Function Speed Phreakery: The FIFO Stock Inventory Problem Sometimes, in the quest for raw SQL performance, you are forced to sacrifice legibility and maintainability of your code, unless... 16 March 2016 14 min read
Enrico van de Laar The SQL Server 2016 Query Store: Forcing Execution Plans using the Query Store The SQL Server 2016 Query Store can give you valuable performance insights by providing several new ways of troubleshooting queries,... 16 March 2016 7 min read
Dennes Torres Creating a Date Dimension in a Tabular Model As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either... 15 March 2016 23 min read
Robert Sheldon SQL Server Metadata Functions: The Basics To be able to make full use of the system catalog to find out more about a database, you need... 09 March 2016 21 min read
Uwe Ricken When AUTO_UPDATE_STATISTICS Doesn’t Happen When your SQL Server database is set to have its statistics automatically updated, you will probably conclude that, whenever the... 07 March 2016 10 min read
Laerte Junior The PoSh DBA: Assigning Data to Variables Via PowerShell Common Parameters Sometimes, it is the small improvements in a language that can make a real difference. PowerShell is able to introduce... 07 March 2016 7 min read
Dennes Torres Creating a Date Dimension in an Analysis Services (SSAS) Cube A walk-through can be a great help to understanding SQL Server Analysis Services, especially when it solves the problem of... 24 February 2016 33 min read
Blogs Phil Factor in Blogs The Luhn Algorithm in SQL The Luhn test is used by most credit card companies to check the basic validity of a credit card number.... 16 February 2016 7 min read
Sander Stad Documenting SQL Server with PowerShell SQL Server instances are generally poorly-documented. How easily can you tell if something has changed? How easily can you check... 11 February 2016 20 min read
Joe Celko SQL GROUP BY Basics It sometimes pays to go back and look at what you think you already know about SQL. Joe Celko gives... 08 February 2016 15 min read
Robert Sheldon Five Online Database Modelling Services To design, or redesign, a database of any complexity, the Entity-Relationship modelling tool becomes essential. The specialized tools that have... 08 February 2016 13 min read
Robert Sheldon SQL Server System Views: The Basics When maintaining or refactoring an unfamiliar database, you'll need a fast way to uncover all sorts of facts about the... 27 January 2016 19 min read
