File Growths
I hinted at file growths in my previous posts about shrinking data and log files. Then I talked about growing log files in my post Database Log VLFs. However,...
2016-03-29
22 reads
Blog Posts
Monday Morning SQL Break – March 28, 2016
It’s Tuesday, and the Monday post is late. A weekend of smoking quite a few pounds of pork kept me in...
2016-03-29
923 reads
2016-03-29
488 reads
My latest presentations
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We...
2016-03-29
911 reads
Nothing To See Here
In a galaxy far, far, far away a developer of a third party application somewhere in the Hoth system had to...
2016-03-29
890 reads
Protecting the SA Account
The sa account is a well, known, built in account for SQL Server. Years ago, in previous
versions, I’d see...
2016-03-29
971 reads
SQL Agent Job Schedules
SQL Agent job schedules should be easy to read for humans if for nothing else than the fact that you have to provide this information to the auditors from...
2016-03-29
6 reads
SQL Server 2016 features: Query Store
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some...
2016-03-29
939 reads
SQL Server 2016 features: Query Store
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some...
2016-03-29
486 reads
SQL Server Failover Cluster Configuration & its Hardware Compatibility
Introduction
Failover cluster in SQL Server is a type of cluster in which two or more independent servers are interconnected with...
2016-03-29
865 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