Azure SQL Database – The Default Isolation Is?
So what is the default isolation level for Azure SQL Database? I ran the following code to check it out....
2018-05-30
419 reads
Blog Posts
Azure SQL Database / SQL Server – Paused Index Rebuild
I was creating some demo non-clustered indexes in one of my Azure SQL Databases and received the following warning when...
2018-05-30 (first published: 2018-05-22)
1,889 reads
Backup and Restore Automation using SQLCMD and SQL Server agent
Database administrators are often requested to refresh a database, mostly to create a live copy of the production database to...
2018-05-30
448 reads
Dates and Times in SQL Server: the problem with DATETIME
Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed...
2018-05-30
452 reads
Getting value out of data quickly
There are times when you need to create a “quick and dirty” solution to build a report. This blog will...
2018-05-30
797 reads
Getting value out of data quickly
There are times when you need to create a “quick and dirty” solution to build a report. This blog will...
2018-05-30
364 reads
Importance of Statistics
Following up on my last post about the Cardinality Estimator let’s talk about column statistics and how they work and...
2018-05-30
587 reads
Lost that SQL Server Access?
Losing access to a SQL instance is never a desirable situation - for the DBA. When the people that are supposed to have access, lose that access, all hope...
2018-05-30
14 reads
Lost that SQL Server Access?
As a data professional can you recall the last time you needed to support a SQL Server instance for which...
2018-05-30
877 reads
The Importance of ORDER BY
Everyone, at the beginning of their SQL career, get’s told that it is important to include an ORDER BY if...
2018-05-30
421 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