MDX – Putting Visual Totals on top or at the bottom
Dynamically totaling child members
Putting the dynamic totals on top or at the bottom can be a trivial or a big...
2016-03-31
1,203 reads
Blog Posts
Ola Hallengren’s solution on a network share using FTP
I use the Ola Hallengren’s maintenance solution for my SQL Servers instances. It happened to run the maintenance solution so that...
2016-03-31
1,004 reads
The ‘In Recovery’ Mystery
Last week I received an email from one of our sysadmins asking why one of our databases kept showing as...
2016-03-31 (first published: 2016-03-22)
1,654 reads
Multiple Tagging of TFS Work Items Using Excel
In my article, TFS tools for managing SQL Server development, I covered several Team Foundation Server (TFS) client tools that can...
2016-03-30
1,006 reads
SQL Server 2016 Azure Virtual Machines
With the release candidates coming thick and fast for SQL Server 2016 downloading, uninstalling the previous version and installing the...
2016-03-30
1,395 reads
SQL Server Service Broker – Introduction
SQL Server Service Broker is a messaging technology that’s baked right into the SQL Server engine. It was first introduced...
2016-03-30 (first published: 2016-03-22)
2,289 reads
When should I test?
To test or not to test. That is the question. Or is it? Shouldn’t we always test? That was the...
2016-03-30
786 reads
Certain DBs in an AG not Backing Up
Last week, I received an alert that the percentage of transaction log in use on one of our production databases...
2016-03-29
980 reads
Do You Teach Azure Data Platform?
I offer instruction on the Azure Data Platform, and have for about six years, since shortly after it came out....
2016-03-29
814 reads
ETL Auditing
It happens far too often: Once an ETL process has been tested and executes successfully, there are no further checks...
2016-03-29 (first published: 2016-03-22)
2,290 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers