T-SQL Programming Phil Factor in T-SQL Programming Visual Checks on How Data is Distributed in SQL Server There are many reasons for wanting to know how data is distributed. Sometimes you just want a rough idea of... 05 May 2017 12 min read
T-SQL Programming Robert Sheldon in T-SQL Programming The Basics of Good T-SQL Coding Style TSQL Code must work properly and efficiently. That's not enough though. Unless you are working alone, have perfect memory and... 05 May 2017 20 min read
Joshua Feierman Azure Load Balancers and SQL Server Load balancing in Azure has more importance for the DBA, because it is essential for Windows Server Failover Clustering in... 25 April 2017 11 min read
Blogs William Brewer in Blogs Generating HTML from SQL Server Queries You can produce HTML from SQL because SQL Server has built-in support for outputting XML, and HTML is best understood... 21 April 2017 11 min read
Blogs Phil Factor in Blogs Statistics in SQL: Simple Linear Regressions Although linear regressions can get complicated, most jobs involving the plotting of a trendline are easy. Simple Linear Regression is... 13 April 2017 4 min read
Blogs Phil Factor in Blogs Statistics in SQL: Kendall’s Tau Rank Correlation Statistical calculations in SQL are often perfectly easy to do. SQL was designed to be a natural fit for calculating... 10 April 2017 6 min read
T-SQL Programming Robert Sheldon in T-SQL Programming Questions About SQL Server Collations You Were Too Shy to Ask Of course we all like our colleagues to think that we know everything there is to know about SQL Server... 06 April 2017 29 min read
BI Krzysztof Stanaszek in BI Scala and Apache Spark in Tandem as a Next-Generation ETL Framework Scala and Apache Spark might seem an unlikely medium for implementing an ETL process, but there are reasons for considering... 06 April 2017 14 min read
Blogs Phil Factor in Blogs Statistics in SQL: Pearson’s Correlation Some people will assure you that you can't do any serious statistical calculations in SQL. In the first of a... 06 April 2017 3 min read
Nat Sundar Comparing SSIS Catalog Contents Using DBFit Framework When you are doing the rapid deployment of an updated SSIS project, there are a number of things you have... 06 April 2017 16 min read
.NET Jon Smith in .NET Building Better Entity Framework Applications Entity Framework (EF) is Microsoft’s Object/Relational (ORM) database access library, with a new generation, EF Core, released in 2016. In... 27 March 2017 22 min read
Database DevOps Phil Factor in Database DevOps Generating Plots Automatically From PowerShell and SQL Server Using Gnuplot When you are automating a number of tasks, or performing a batch of tests, you want a way of automating... 27 March 2017 12 min read
Joshua Feierman Azure Networking for SQL Server DBAs The network is important to any DBA because so much performance is dependent on I/O, because of the importance of... 27 March 2017 15 min read
T-SQL Programming Nat Sundar in T-SQL Programming Using the DbFit Framework for Data Warehouse Regression Testing It is ironic that the users of database application need to rely on the very technologists that created the system... 08 March 2017 15 min read
T-SQL Programming Robert Sheldon in T-SQL Programming Encrypting SQL Server: Dynamic Data Masking Dynamic Data Masking is a good way of rendering data unreadable for such purposes as user-acceptance testing, or demonstrating an... 08 March 2017 15 min read
David Njoku Oracle for Absolute Beginners: Users, Synonyms, Privileges, & Roles I accidentally locked myself out of my house this evening, and so I had to climb up the wall like... 01 March 2017 11 min read
BI Saurabh Desai in BI Using an R Package within SQL Server with Real time analysis in Power BI We all know how easy it is to run R, together with dependent packages, from SQL Server on order to... 28 February 2017 14 min read
BI Nat Sundar in BI Deploying Multiple SSIS Projects via PowerShell When there are several SSIS projects with packages in a SQL Server Database or Data Warehouse development, automated deployments as... 27 February 2017 29 min read
Database Administration Joshua Feierman in Database Administration Exploring Azure Storage for SQL Server DBAs – Part 2 Managed Disks have simplified way that Azure storage interacts with the users' virtual machines, thanks to the way that it... 27 February 2017 15 min read
T-SQL Programming Phil Factor in T-SQL Programming Doing Fuzzy Searches in SQL Server A series of arguments with developers who insist that fuzzy searches or spell-checking be done within the application rather then... 23 February 2017 17 min read
