T-SQL Programming Joe Celko in T-SQL Programming Handling Graphs in SQL Many practical database problems can be tackled more simply and intuitively by graphs or networks, which in this sense are... 20 January 2017 17 min read
Oracle Aman Sharma in Oracle Understanding SQL Query Parsing – Part 3: Bind Variables and Cursor Sharing In the first and the second parts of this series, we learned what query parsing is, how hard and soft... 20 January 2017 10 min read
T-SQL Programming Robert Sheldon in T-SQL Programming Core Database Source Control Concepts Sometimes, it isn't the technicalities or details of database source control that people find difficult, but the general concepts and... 13 January 2017 30 min read
T-SQL Programming Robert Sheldon in T-SQL Programming Encrypting SQL Server: Transparent Data Encryption (TDE) Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the... 12 January 2017 16 min read
BI Nat Sundar in BI Deployment Automation for SQL Server Integration Services (SSIS) SSIS was not originally designed with automated deployment in mind. However, any database that uses SSIS projects and their packages... 12 January 2017 16 min read
Database Administration Joshua Feierman in Database Administration Exploring Azure Storage for SQL Server DBAs If you need to run SQL Server in an Azure Virtual Machine, your choice of Azure storage will have a... 04 January 2017 14 min read
Database Administration Enrico van de Laar in Database Administration Query Store and In-Memory OLTP Once you have Query Store enabled on your databases, runtime statistics are generated for your queries; but what about the... 04 January 2017 11 min read
T-SQL Programming Robert Sheldon in T-SQL Programming Encrypting SQL Server: Using an Encryption Hierarchy to Protect Column Data SQL Server Encryption is an essential part of what is required for protecting data. Column-level encryption can be a very... 13 December 2016 15 min read
T-SQL Programming Phil Factor in T-SQL Programming Lists With, or Without, Ranges in both T-SQL and PowerShell Whether you are working in a procedural language like PowerShell or in T-SQL, there is something slightly bothersome about having... 01 December 2016 19 min read
BI Rahul Gupta in BI Reconciling Data Across Systems Using a Reconciliation Hub In many enterprises, where there are a number of separate systems engaged in processing data, there arises the daunting task... 01 December 2016 13 min read
Database Administration Enrico van de Laar in Database Administration Determining What Happens When You Force an Execution Plan via the Query Store When you force a query plan via the Query Store, you will need to track what happens: Sometimes the request... 29 November 2016 12 min read
Database Administration Robert Sheldon in Database Administration Using Power BI Desktop to Visualize SQL Server Metadata You can easily use PowerBI Desktop to show graphically how your database is growing, which tables are taking the most... 16 November 2016 18 min read
Database DevOps Grant Fritchey in Database DevOps SQL Server Database Provisioning Database provisioning for development work isn't always easy. The better that development teams meet business demands for rapid delivery and... 04 November 2016 8 min read
T-SQL Programming Phil Factor in T-SQL Programming Using SQLite with PowerShell and SQL Server When you combine PowerShell and SQLite, you can perform powerful magic. Phil Factor is in awe of SQLite and gives... 03 November 2016 14 min read
T-SQL Programming Joe Celko in T-SQL Programming Triggers: Threat or Menace? Triggers are generally over-used in SQL Server. They are only rarely necessary, can cause performance issues, and are tricky to... 27 October 2016 13 min read
BI Robert Sheldon in BI Importing Excel Data into Power BI Desktop In any commercial setting, Excel Spreadsheets remain the preferred way of collecting and analysing data, and it makes sense that... 26 October 2016 13 min read
Database Administration Robert Sheldon in Database Administration Retrieving SQL Server Query Execution Plans Execution plans explain all you need to know about query performance, and how to fine-tune. Sure, you can see them... 18 October 2016 26 min read
Database Administration Phil Factor in Database Administration Representing Hierarchical Data for Mere Mortals Why is it that we use XML, but with so little enthusiasm when it does so much, and is so... 06 October 2016 20 min read
T-SQL Programming Grant Fritchey in T-SQL Programming Who the Devil Wrote This SQL Code? The way that you format T-SQL code can affect the productivity of the people who have to subsequently maintain your... 05 October 2016 12 min read
T-SQL Programming Edward Elliott in T-SQL Programming Which Edition of SQL Server is Best for Development Work? You might think, as a developer, that nothing but the best is good enough as a development database. You might... 04 October 2016 15 min read
