Compressing Outcomes
You find yourself cruising along, just doing your thing as a database administrator. Then the CIO plops down into a...
2015-08-24
716 reads
SQL RNNR
Compressing Outcomes
Find yourself struggling to determine the outcome of attempted compression settings in your database? This should help!
Related Posts:
Failed to Create the Audit File December 31, 2017
Disk Space and...
2015-08-24
4 reads
Tables, Columns and Defaults Oh My!
Picture this if you could. You inherit a new database either through the change of a job, or finding a...
2015-08-31 (first published: 2015-08-19)
2,013 reads
Tables, Columns and Defaults Oh My!
The joys of inheriting a new database and being thrown into the fire to quickly assimilate as much information about the database as possible can be troublesome. This script...
2015-08-19
2 reads
Compressing Encrypted Backups
A common requirement, whether it be based out of pure want or truly out of necessity, is to make a...
2015-08-11
3,338 reads
Compressing Encrypted Backups
A common requirement, whether it be based out of pure want or truly out of necessity, is to make a large database backup file, that is encrypted, be much...
2015-08-11
5 reads
What is DBCC?
If I ask you what is DBCC, what would your answer be?
I want you to think about that one for...
2015-08-11
10,660 reads
What is DBCC?
What is really mean by DBCC and what do people mean when they say DBCC?
Related Posts:
Database Corruption and IO Errors January 18, 2018
Common Tempdb Trace Flags - Back...
2015-08-11
41 reads
HealthySQL – A Review
How well do you know the health of your SQL Servers and databases? Ever wonder about the current health or...
2015-08-14 (first published: 2015-08-07)
2,240 reads
HealthySQL – A Review
A quick look into the book by Robert Pearl: Healthy SQL.
Related Posts:
My Book Contributions November 30, 2018
Profiler for Extended Events: Quick Settings March 5, 2018
How to be...
2015-08-07
9 reads
Blogs
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...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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