BI Kathi Kellenberger in BI Reporting Services Basics: Overview and Installation SQL Server Reporting Services has changed quite a bit since it was introduced in 2004. Despite new analytic services like... 08 April 2019 16 min read
NoSQL Adam Aspin in NoSQL SQL For Cosmos DB – Tips and Tricks Building on the introduction to the SQL used by Cosmos DB in the first article in the series, here you... 03 April 2019 9 min read
Oracle Cynthia Dzikiti in Oracle Security Considerations for ERP Applications Security is, or at least should be, the priority for any IT system. In this article, Cynthia Dzikiti discusses the... 01 April 2019 16 min read
T-SQL Programming Mala Mahadevan in T-SQL Programming Converting a History Table into a System-Versioned Temporal Table Temporal tables were introduced with SQL Server 2016. To take advantage of this feature, you might start fresh with a... 13 March 2019 15 min read
Editorials Kendra Little in Editorials Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures “There are only two hard things in Computer Science: cache invalidation and naming things” Phil Karlton I’m terrible at naming... 12 March 2019 4 min read
NoSQL Adam Aspin in NoSQL Introduction to SQL for Cosmos DB This article by Adam Aspin reviews the Azure Cosmos DB SQL API from the perspective of the relational database developer.... 06 March 2019 22 min read
Database Administration Greg Larsen in Database Administration Resumable Online Index Create and Rebuild Operations Index maintenance can be a real headache for database administrators as tables grow larger and maintenance windows shrink. In this... 05 March 2019 14 min read
T-SQL Programming Phil Factor in T-SQL Programming What are Inline Indexes? New releases of SQL Server arrive at a quick pace, and it's difficult to keep up with the many features... 26 February 2019 13 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 3 SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the... 25 February 2019 14 min read
BI Gogula Aryalingam in BI The BI Journey: The Expert’s Advice – Part 1 Creating a quick dashboard with a few reports may be the beginning of a BI solution, but unless time is... 20 February 2019 14 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming The Performance of Window Aggregates Revisited with SQL Server 2019 T-SQL window functions have been a fantastic addition to the T-SQL language. In this article, Kathi Kellenberger reviews how optimizations... 11 February 2019 11 min read
NoSQL Pushpa Sekhara Reddy Matli in NoSQL Apache Cassandra Data Modeling and Query Best Practices Organizations have many choices when it comes to database platforms. Choosing the right one for an application should be based... 07 February 2019 11 min read
PowerShell Greg Moore in PowerShell Using a Server List to Control PowerShell Scripts PowerShell is the preferred tool for many DBAs when automating SQL Server administration. In this article, Greg Moore demonstrates how... 29 January 2019 13 min read
BI Gogula Aryalingam in BI The BI Journey: The Analyst Most organizations today understand the value of analysing their data. In some cases, they haven’t realized the value or are... 21 January 2019 15 min read
BI Andy Brown in BI Using the DAX Calculate and Values Functions In the first two articles in this series on creating DAX formulae, Andy Brown of Wise Owl Training showed how... 14 January 2019 20 min read
T-SQL Programming Joe Celko in T-SQL Programming Empty Thoughts: Working with NULL Whether or not to have NULLable columns in a table can be a religious debate, and how missing data is... 10 January 2019 12 min read
Database Administration Greg Larsen in Database Administration Protecting SQL Server Data Using Static Data Masking In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by developers and... 07 January 2019 19 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 1 Security is often considered the most important of a database administrator's responsibilities. SQL Server has many powerful features for security... 31 December 2018 14 min read
BI Andy Brown in BI Creating Measures Using DAX In the first article in this series, Andy Brown demonstrated how to create calculated columns in Power BI using the... 28 December 2018 22 min read
T-SQL Programming Phil Factor in T-SQL Programming Saving Data to Various Formats, Using SQL You have many options when exporting data from a database. In this article, Phil Factor compares several methods including XML... 24 December 2018 12 min read
