T-SQL Tricks – Customizing SSMS Templates with Parameters
I wrote briefly about templates in Management Studio (SSMS), and showed the default templates that come with SQL Server. I...
2014-12-11 (first published: 2014-12-03)
7,052 reads
Blog Posts
Video – Identifying large queries using Extended Events
A couple of weeks ago I was contacted by Webucator (an online training company) asking if they could use my...
2014-12-11 (first published: 2014-12-05)
2,363 reads
Converting Dates
I ran across a post recently where someone had dates stored as characters (never good), but also in this format:...
2014-12-10
858 reads
On Perspective
Perspective can make or break a career. Maintaining a proper perspective is very often the differentiating factor between a good...
2014-12-10 (first published: 2014-12-03)
5,657 reads
Runbooks in SQL Azure
Runbooks in SQL Azure
DECEMBER 2, 2014
SQL Azure Runbooks promise to be your “SQL Server Agent in the cloud”. They enable you to use PowerShell Scripts inside of SQL Azure...
2014-12-10
51 reads
Runbooks in SQL Azure
Runbooks in SQL AzureDECEMBER 2, 2014SQL Azure Runbooks promise to be your “SQL Server Agent in the cloud”. They enable...
2014-12-10
1,359 reads
Sequence feature TIP #76
Although it is a old feature for those who knows ORACLE but for SQL server developers it is a new...
2014-12-10
265 reads
SQL Saturday NYC Update #2
Just over 2 weeks now since SQL Saturday NYC went live and planning is in full force. An update on...
2014-12-10
321 reads
SQL Server Bugs That Might Bite You
I’m on my way to give a presentation at the PASS Database Administration Virtual Chapter about SQL Server bugs. All the materials...
2014-12-10
499 reads
The Modern Data Warehouse
The traditional data warehouse has served us well for many years, but new trends are causing it to break in...
2014-12-10 (first published: 2014-12-03)
11,535 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