Hello!
It is my birthday: another year older, another year not necessarily wiser. I’m planning on spending the evening watching the BBC and eating pizza. There are worse ways to...
2018-05-31
7 reads
I gave a presentation at SQL Day in Poland last week on dbachecks and one of the questions I got...
2018-05-31 (first published: 2018-05-23)
3,052 reads
It’s actually a simple procedure, but I thought I’d write a short note to help me remember. The procedure is...
2018-05-31
480 reads
Power BI Report Server was released as a way to host reports on premises. It was one of the highest...
2018-05-31
522 reads
Starting SQL Server in single-user mode should be a tool every data professional holds in the bag. This is an essential tool that can be used in multiple scenarios...
2018-05-31
296 reads
In a recent article, I took you on a trip through how to hack (ethically) a SQL Server to regain...
2018-05-31
562 reads
For those not aware there’s some excellent local SQL events coming up here in Melbourne and Sydney…
SQL Saturday769 (Sat 30 Jun 2018)...
2018-05-31
377 reads
For those not aware there’s some excellent local SQL events coming up here in Melbourne and Sydney… SQL Saturday 769 (Sat 30 Jun 2018) Melbourne. SQL Saturday 771 (Sat 07 Jul 2017)...
2018-05-31
4 reads
This is one of my favorite scripts. It pulls all of the data from the error log and dumps it...
2018-05-31
379 reads
Occasionally I will come across the need to use PowerShell for my day to day activities. One such need came...
2018-05-30 (first published: 2018-05-22)
2,191 reads
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item 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