MS Ignite Day#1 Recap
What an amazing first day at Microsoft Ignite that all started at about 6:30 this morning when I got in line to be one of the first 3000...
2019-11-05
96 reads
Blog Posts
PowerShell Notebooks are Available in Azure Data Studio
PowerShell Notebooks are now available in the November release of Azure Data Studio. Back in March I requested this feature be added to Azure Data Studio and it has...
2019-11-05
14 reads
PowerShell Notebooks are Available in Azure Data Studio
PowerShell Notebooks are now available in the November release of Azure Data Studio. Back in March I requested this feature be added to Azure Data Studio and it has...
2019-11-05
35 reads
Smart Tlog Bkp
another great new feature for SQL Server 2017 is a smart backup with dmv sys.dm_db_log_space_usage this DMV provide log usage information using this we can plan to initiate the...
2019-11-05
22 reads
Speaking at PASS Summit 2019
As I announced before, I had the honor to be selected as speaker for PASS Summit this year. This is a huge deal for me as data professional and...
2019-11-05
19 reads
SQL Server 2019 GA
Yes, Finally SQL Server 2019 is Generally Available yesterday Nov 4th 2019. It has many great features great videos: https://channel9.msdn.com/Niners/dutchdatadude https://cloudblogs.microsoft.com/sqlserver/2019/11/04/gain-intelligence-over-data-with-sql-server-2019-now-generally-available/ https://cloudblogs.microsoft.com/sqlserver/2019/11/04/sql-server-2019-is-now-generally-available/
2019-11-05
87 reads
SQL Undercover TV – Using Excel to Visualise SQL Performance Data
Adrian looks at how you can use Excel to visualise SQL performance data, specifically data collected by the Blitz First Responder Kit
2019-11-05
110 reads
SQLSaturday Orlando Notes – SpeedPASS
This year for the first time in a long time we pre-printed the SpeedPASS for all attendees and we did it on perforated paper. This was really all about...
2019-11-05
57 reads
Tips to build a your-departure-proof leadership team in your tech community
This is a fairly poignant issue for many technical community leaders who feel alone in what can be a thankless job. Let's talk about some guidance and tips for...
2019-11-05
12 reads
T-SQL Tuesday #120 – What were you thinking? – Invitation
In this month's T-SQL Tuesday, I want to know about things that you have seen someone do in SQL Server that has left you wonder "What were you thinking?"
The...
2019-11-05
16 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