T-SQL Tuesday Retrospective #012: Why DBA skills are necessary
This is my ongoing series of answering T-SQL Tuesday posts far too late to be of any use. Click here if you want to read previous entries. Paul Randal...
2021-03-17
138 reads
Blog Posts
?????????????????????????? ???????????????????? ?????????????????? ???? ?????????????????? ?????? – DP 300
?????????????????????? ???? ??????’?? ?????? ???? ?????????? ?????????????????? I have a very important announcement to make to all of you. Today on my birthday(16th March), I feel delighted and proud...
2021-03-16
27 reads
Daily Coping 16 Mar 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-03-16
24 reads
Data dictionary script
I restarted speaking with New Stars of Data today – I gave a talk on Database documentation. Below is the script I created to pull metadata into an excel...
2021-03-16 (first published: 2021-03-12)
710 reads
T-SQL Tuesday Retrospective #011: Misconceptions
(If you would like to read the previous T-SQL Tuesday Retrospective entries, visit this link.) In October 2010, Sankar Reddy asked us which misconceptions we’ve been labouring under when...
2021-03-16 (first published: 2021-03-10)
310 reads
Apologies
Hello all! I wanted to apologize to you. I haven’t been keeping up with the blog well at all over the last couple of months. I have simply been...
2021-03-15
30 reads
Daily Coping 15 Mar 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-03-15
13 reads
Getting SQL Services Information with Powershell
Hopefully you already know everything about your SQL estate, including what services are installed and what’s running them, either because it’s so small you just know, or, preferably, you...
2021-03-15
32 reads
How SQL Server Synonyms Help Database DevOps
Synonyms inside SQL Server are one of those useful but forgotten features. A synonym is a database level object that allows you to provide an alternative name for another...
2021-03-15 (first published: 2021-03-10)
300 reads
My new Home Studio Setup
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-03-15
11 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