An Introduction to GitHub for DBAs
Distributed source control is really intimidating: branches, pull requests, merges – will somebody just take my code, for crying out loud? Why does it have to be so complicated and involved?
2019-02-22
3,826 reads
Articles
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 just getting started. This article, by Data Platform MVP Gogula Aryalingam, describes how analytics can start small – with just one Power BI dashboard – and grow from there.
2019-02-21
3,439 reads
Azure Data Lake Analytics using U-SQL Queries
This article will help with gaining confidence and familiarity with Microsoft Azure's Data Lake Analytics offering to process large datasets quickly while demonstrating the potential and capabilities of U-SQL to aggregate and process big data files.
2019-02-20
2,259 reads
Learning about DML Triggers
Triggers can be confusing and complex for many developers new to SQL. Steve Jones gives a few ideas for learning more about this construct as well as practicing writing them.
2019-02-19
2,951 reads
2019-02-19
5,335 reads
GDPR - A guide for the perplexed
If a picture paints a thousand words then can GDPR regulation be represented in diagram form? Could doing so make it easier to comply with the regulation by making it easier to understand?
2019-02-18 (first published: 2018-01-11)
4,912 reads
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 to create calculated columns and measures. In this third article, he turns his attention to two of the most important DAX functions (CALCULATE and VALUES), showing how and when to use them. If DAX knowledge can be compared to a heavily fortified castle, the CALCULATE function is the drawbridge giving access to it.
2019-02-18
2,279 reads
Using Power BI and SSRS for visualizing SQL Server and R data (Part 4)
Using R with Power BI, SSRS or RTVS for easier data visualization
2019-02-15 (first published: 2017-01-24)
4,460 reads
Why Redgate is Running a Database Development Disasters Contest?
Kendra Little explains why Redgate would like to hear your stories of how the database has been left behind.
2019-02-14
255 reads
SQL Server Perfmon counters that are still interesting in 2019
Years ago, my first go-to tool for performance tuning was Performance Monitor: it was available everywhere, worked in all versions, and gave me a lot of useful information without paying for a monitoring tool. Since then, I’ve moved on – wait stats are a much better starting point – but there are still 3 good Perfmon counters that I rely on.
2019-02-13
2,442 reads
Blogs
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers