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
BI Robert Sheldon in BI More Power BI to your Elbow Power BI Desktop continues to evolve. There have been many improvements to the reporting side that together make it easier... 20 September 2016 14 min read
BI Adam Aspin in BI Power BI for Data Modelling Power BI has a lot of uses, but one of the most interesting of them is to model and shape... 16 September 2016 24 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
Database Administration Shel Burkow in Database Administration In-Memory OLTP: Row Visibility in SQL Server’s MVCC SQL Server's In-memory OLTP is fast, due to its multi-valued concurrency control (MVCC). MVCC avoids the need for locks by... 05 September 2016 15 min read
T-SQL Programming Uwe Ricken in T-SQL Programming DELETE Operation in SQL Server HEAPs You should stick to using tables in SQL Server, rather than heaps that have no clustered index, unless you have... 05 September 2016 14 min read
Blogs Phil Factor in Blogs The SQL of Textonyms The task of finding textonyms in SQL involves importing a list of common words and doing transformations on every word... 31 August 2016 14 min read
T-SQL Programming Joe Celko in T-SQL Programming Predicates With Subqueries The ALL, SOME and ANY predicates aren't much used in SQL Server, but they are there. You can use the... 25 August 2016 12 min read
Database Administration Robert Sheldon in Database Administration SQL Server for Linux Although SQL Server for Linux removes the concern that adopting SQL Server forces you to also adopt the Windows platform,... 25 August 2016 11 min read
BI Adam Aspin in BI Direct Query with Power BI Power BI allows you to connect directly to the data just as if it were a “standard” connection, and modify... 10 August 2016 30 min read
T-SQL Programming Joe Celko in T-SQL Programming Formatting SQL Code – Part the Second When you're formatting SQL Code, your objective is to make the code as easy to read with understanding as is... 10 August 2016 15 min read
Database Administration Robert Sheldon in Database Administration SQL Server Access Control: The Basics No technology yet invented can in any way allow us to neglect the task of ensuring the security of the... 02 August 2016 17 min read
Performance Robert Sheldon in Performance SQL Server Statistics Basics Distribution statistics are used by SQL Server's Query Optimiser to determine a good execution plan for your SQL query. You... 22 July 2016 17 min read
T-SQL Programming Joe Celko in T-SQL Programming Formatting SQL Code – Part the First With the formatting of code, we sometimes do things because they've always been done that way, rather than making code... 22 July 2016 16 min read
