Activity Monitor and Profiler
Today I came across a link to a neat little script for SQL 2005 / 2008 to help derive the head...
2011-07-28
1,990 reads
Blog Posts
Bad Admins: Non-Production Servers
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-28
2,179 reads
Do You Work for #1?
Someone recently asked me if I would work for a company if I didn’t believe in their products or services...
2011-07-28
648 reads
How to move Cluster MSDTC Drive
I recently had the need to move the MSDTC for a cluster to a new SAN drive. It’s a quite simple...
2011-07-28
2,856 reads
T-SQL refactoring
Keeping your SQL objects’ naming rules during furious development is hard. New levels of information are added continuously, entities are...
2011-07-28
2,733 reads
When Did That Restore Finish?
I saw this question come across Twitter under the #sqlhelp tag one day and was wondering myself. Someone suggested the...
2011-07-28
7,597 reads
Exceptional DBA of the Year 2011 - Please vote for Jeff Moden
Every year Redgate has a competition to find the most
exceptional DBA of the year. This year too they are conducting....
2011-07-27
1,600 reads
Lookup functions in SSRS 2008 R2 - II
Introduction
In my last post on Lookup functions related to SSRS 2008 R2, I had explained Lookup(). It is used to...
2011-07-27
8,555 reads
Preparing for #sqlsat81
SQL Saturday 81 is coming up this weekend in Birmingham AL. This will be my 5th SQL Saturday to speak...
2011-07-27
589 reads
Searching for Wild Card Characters
I got asked an interesting question recently, I was demonstrating how you can use wild cards in a WHERE clauses...
2011-07-27
772 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