SQLBits 7
For those that may of missed it, voting for SQLBits sessions is now open. Make your voice heard and get...
2010-07-20
399 reads
Blog Posts
SSIS - Event Handler Performance
Event handlers are a great tool for managing errors and other events that occur during the execution of a package...
2010-07-20
1,140 reads
Creating UDL Files On The Fly
Many years ago, in the dark ages of DTS I created a little app that would take two parameters and...
2010-07-19
659 reads
Finding Your Next Job
We’ve had a few people in the SQL community find jobs lately and many of them attributable to their network....
2010-07-19
518 reads
How to Deal with Quebec’s Extremists: Expose Their Malfeasance Publicly?
NB - to my regular blog readers, excuse the tangent here, but the local provincial extremists attempted something in my 'hood...
2010-07-19
6,754 reads
I Did It - PASS Nomination Application
I send my board of directors nomination application to PASS and asked for a confirmation. I always worry that something...
2010-07-19
675 reads
I’m All In – Running for the PASS Board
Yes, I’m going to run for the PASS Board of Directors. I have my application and will be sending it out...
2010-07-19
537 reads
Increasing or Decreasing Sampling Size in SSAS Data Source View Data Explorer
Recently, I have begun my quest of mastering SSAS. I realize that it may take time and I am more...
2010-07-19
503 reads
It’s the Journey
I saw this on the 37 Signals blog as “I’ve already got the prize" and found it to be both...
2010-07-19
663 reads
SQL Server 2008 Installation on Windows 7 - Help is finally here!
Whatever edition of SQL Server 2008, regardless of it being 32-bit or 64-bit, chances are, if you’re installing SQL Server...
2010-07-19
57,918 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