Using AT TIME ZONE to fix an old report
Rob Farley contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time zone.
2017-03-27
4,087 reads
Articles
The Mysterious Case of the Missing Default Value
Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.
2017-03-24 (first published: 2015-12-01)
7,011 reads
Encrypting SQL Server: Transparent Data Encryption (TDE)
Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the original encryption certificate and master key, the data cannot be read when the drive is accessed or the physical media is stolen. The data in unencrypted data files can be read by restoring the files to another server. TDE requires planning but can be implemented without changing the database. Robert Sheldon explains how to implement TDE.
2017-03-24
5,410 reads
Comparing Space Usage for Different Compression Types
This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.
2017-03-23
2,364 reads
Getting Started with Azure SQL Data Warehouse - Part 2
Arshad Ali discusses the architecture of Azure SQL Data Warehouse and how you can scale up or down, based on your need.
2017-03-23
4,160 reads
Continuous Delivery and the Development DBA
How to do database development with trunk based development and Continuous Delivery
2017-03-22
2,388 reads
Follow-up #1 on leading wildcard seeks
Aaron Bertrand shows how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.
2017-03-22
4,058 reads
Core Database Source Control Concepts
Sometimes, it isn't the technicalities or details of database source control that people find difficult, but the general concepts and workflow. In this article, taken from Robert Sheldon's book 'SQL Server Source Control Basics' , he takes a step back from the details to explain the whole purpose of database source control and the most important operations within source control such as versioning, branching and merging.
2017-03-21
5,188 reads
Backups in Azure SQL Data Warehouse
This time we explain how to recover an Azure SQL Data Warehouse (ASDW) from a disaster.
2017-03-20
3,643 reads
Using Power BI in a Hybrid Environment
Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores. This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources.
2017-03-20
4,239 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers