Blogs Dennes Torres in Blogs Using R to illustrate relationships from graph objects My new article about Graph Database Objects was just published, it’s really a very good new feature. Another new feature... 06 July 2017 3 min read
T-SQL Programming Dennes Torres in T-SQL Programming SQL Graph Objects in SQL Server 2017: the Good and the Bad Graph databases are useful for certain types of database tasks that involve representing and traversing complex relationships between entities. These... 05 July 2017 28 min read
Phil Factor Statistics in SQL: The Mann–Whitney U test Imagine you have some data. Maybe you’ve done a web redesign and you want to do some A/B testing to... 30 June 2017 6 min read
Blogs Dennes Torres in Blogs SQL Server 2017: New ‘Queries with high variation’ Graph A few weeks ago I published an interesting article about how to use query store to identify parameterization problems. At... 30 June 2017 3 min read
Blogs Dennes Torres in Blogs New T-SQL Functions in SQL Server 2017 SQL Server 2017 brings us some new T-SQL functions. They are very simple to use, and can also help us... 28 June 2017 5 min read
T-SQL Programming Robert Sheldon in T-SQL Programming The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data SQL was designed to be a third-generation language, expressed in syntax close to real language, because it was designed to... 27 June 2017 17 min read
Database Administration Laerte Junior in Database Administration Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment Although Azure is the obvious Cloud service to host SQL Server, Amazon Relational Database Service (RDS) for SQL Server is... 27 June 2017 8 min read
Blogs Phil Factor in Blogs Is It Time To Stop Using IsNumeric()? The old system function IsNumeric() often causes exasperation to a developer who is unfamiliar with the quirks of Transact SQL.... 23 June 2017 12 min read
Database DevOps William Brewer in Database DevOps Database Code Analysis Database code analysis will reduce the number of 'code smells' that creep into your database builds. It will alert the... 20 June 2017 12 min read
Blogs Dennes Torres in Blogs SQL 2017 new DMF: Managing VLOGs in our databases SQL Server 2017 brings to us some new interesting DMV’s and DMF’s, one of them is sys.dm_db_log_info. This new DMF... 20 June 2017 4 min read
BI Robert Sheldon in BI SQL Server R Services: The Basics It is possible to do a great deal with R within SQL Server, but it is best to start by... 19 June 2017 18 min read
BI Amarendra Reddy Thummeti in BI Developing Metadata Design Patterns in BIML You may have already experienced ETL Hell, where you have a large number of similar of SSIS tasks, and a... 06 June 2017 22 min read
Database Administration Dennes Torres in Database Administration Query Store and Parameterization Problems The query store gives us a novel way of identifying those queries that are causing performance problems when they are... 06 June 2017 25 min read
T-SQL Programming Robert Sheldon in T-SQL Programming The Basics of Good T-SQL Coding Style – Part 2: Defining Database Objects Technical debt is a real problem in database development, where corners have been cut in the rush to keep to... 02 June 2017 22 min read
Blogs Dennes Torres in Blogs News for Differential Backup SQL Server 2017 brings several improvements to us. Sometimes a simple new field in a DMV can turn possible interesting... 02 June 2017 4 min read
Blogs Phil Factor in Blogs Statistics in SQL: The Kruskal–Wallis Test Before you report your conclusions about your data, have you checked whether your 'actionable' figures occurred by chance? The Kruskal-Wallis... 01 June 2017 4 min read
Blogs Dennes Torres in Blogs Simultaneous Auto-growth in Multiple Files SQL Server 2016 has a new configuration to control the auto-growth of multiple files in the same filegroup. When we... 27 May 2017 4 min read
Phil Factor SQL Server User-Defined Functions User-Defined Functions (UDFs) are an essential part of the database developers' armoury. They are extraordinarily versatile, but just because you... 23 May 2017 26 min read
T-SQL Programming Joe Celko in T-SQL Programming Simple SQL: Attribute Splitting If the design of a relational database is wrong, no amount of clever DML SQL will make it work well.... 23 May 2017 11 min read
BI Saurabh Desai in BI Deploying, Securing, and Updating Power BI Reports Before Excel and other data-linked spreadsheets, business reports needed to be hand-crafted by IT experts, and changes were arbitrated slowly... 19 May 2017 13 min read
