A Guest at the Ranch
From the other side of the world, I had a guest at the ranch today.
Pinal Dave, a friend from...
2011-07-19
814 reads
Blog Posts
Denali–IIF and CHOOSE
In Denali CTP3, we have a new of new functions to play with. For this post, im going to focus...
2011-07-19
795 reads
Knowing Someone Makes a Difference-Part 1
I’ve put a lot more emphasis on networking in the last few years and I’ve always considered it an investment,...
2011-07-19
615 reads
SQL in the City (London) is a Great Success
This is what my audience looked like from the stage just before I started speaking at the first of my...
2011-07-19
997 reads
SQL Server – SET STATISTICS [IO|TIME] ON
My colleagues and I often joke around with “If it takes less than a second, then it’s okay!”. The reason...
2011-07-19
1,459 reads
The SQLSaturday Sensation - Celebrating the 100th Event!
The SQLSaturday Sensation!
Congratulations, Brazil! You are the recipient host country for SQLSaturday #100!! On Saturday, November 26, 2011, when the...
2011-07-19
2,435 reads
Un-SQL Friday #005: Bad Interviews
Yesterday a friend told me a tale of an interview he conducted with a, shall we say, less than desirable...
2011-07-19
701 reads
Vote for the 2011 Exceptional DBA of the Year Award
It’s been my experience that most DBA’s aren’t properly recognized for their contributions to their organizations. As the “protectors of...
2011-07-19
727 reads
Denali SQLPS First Impressions
I’ve taken a few hours to try out Denali CTP 3 sqlps and noticed some welcome changes. The biggest change...
2011-07-18
2,039 reads
Event: NJSQL UG Tomorrow 7/19 - Management Data Warehouse
If you're in the local NY/NJ Tri-State area, and planning on attending, this is a reminder from the New Jersey...
2011-07-18
690 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
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...
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