2016-11-14
486 reads
Blog Posts
A Data Professional’s Story – PASS Summit 2016
This year is different. Why? I’m not sure yet. There is a lot of reflection going on since my return...
2016-11-11 (first published: 2016-11-02)
1,231 reads
Creating Custom Databases with SQL Prompt
SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself...
2016-11-11 (first published: 2016-11-01)
1,677 reads
Friday Reading 2016-11-11
It’s Friday so no releases to Production today (ha!) which means in-between my code reviews, server audits and other tasks...
2016-11-11
294 reads
How to deploy your SQL Server database to a remote server
CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server where the target database is.
First time deployment
Backup / restore...
2016-11-11
6 reads
How to deploy your SQL Server database to a remote server
CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server...
2016-11-11
2,121 reads
Linked Server Security
Problem
When creating Linked Servers, security often gets overlooked. This can lead to accounts on one instance having access, sometimes with...
2016-11-11
22,306 reads
Special Index - XML Index
I will be writing this series of articles for the Special Indexes in SQL Server. In this series we will...
2016-11-11
505 reads
What does an Index mean to a Query
This post is about the importance of a right index to a query. The following simple query was considered. [crayon-5e96566159ca8644006533/] Even simple, this query was causing troubles on our production...
2016-11-11
9 reads
What does an Index mean to a Query
This post is about the importance of a right index to a query. The following simple query was considered.<?query --SELECT [GroupBy1].[A1]...
2016-11-11
334 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