Scoring Outliers in Non-Normal Data with R
Using R to detect outliers is relatively easy, but most methods assume your data is normally distributed. How do you handle skewed datasets?
2017-06-29
5,566 reads
Articles
Azure Automation Methods
Tim Radney of SQLskills walks through multiple automation methods you can use to manage and maintain your Azure SQL Databases.
2017-06-29
3,697 reads
Replace Bad Characters in Table
Learn how to clean bad characters from lots of data in this article.
2017-06-28
3,480 reads
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 as a slightly odd dialect of XML that imparts meaning to predefined tags. There are plenty of edge cases where an HTML structure is the most obvious way of communicating tables, lists and directories. Where data is hierarchical, it can make even more sense. William Brewer gives a simple introduction to a few HTML-output techniques.
2017-06-28
5,489 reads
Filegroup Restoring and Database Consistency
In this article, we'll explore a less used feature of SQL Server: filegroup restoring, feature that has an interesting consequence because database can become inconsistent without any warning and standard checks don't reveal any issue.
2017-06-27
3,613 reads
How to Read the Transaction Log File
Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.
2017-06-27
4,882 reads
Workplace Encounters: Using Volume Mount Points in SQL FCIs
How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points
2017-06-26
1,023 reads
A DLM Approach to Database Testing
Database Lifecycle Management aims to make the development and modification of databases more predictable. Bugs are the source of more unpredictability than anything else, purely because it is so difficult to guess how long it will take to fix them. Good testing at all stages may take some time and effort, but it greatly reduces likelihood of the wildcard factor of the bug that is first detected during the deployment process; or worse, that gets into the production release.
2017-06-26
3,875 reads
Getting Started with Azure SQL Data Warehouse - Part 5
In part 5 of this series covering Azure SQL Data Warehouse, Arshad Ali looks at performance optimization.
2017-06-23
3,202 reads
Where's the Ops in DevOps? Part 1
In the first of a three-part series, guest bloggers from DevOpsGuys look at the real role of Ops in DevOps. Where it changes, how it changes, and why Ops...
2017-06-23
3,752 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Solutions for Environmental and Pollution Testing | Fare Labs Pvt. Ltd.
The state-of-the-art FARE Labs Environmental Testing Laboratory provides a broad range of testing services...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers