Some Common Disk Drives Compared
Since I talked about how wonderful the newer Western Digital Black 6Gbps SATA III hard drives are a couple of...
2011-07-27
1,117 reads
Blog Posts
SQL Server does not script indexes by default
Here is a got-ya that happened to me. In SQL Server I want to generate a script of all the...
2011-07-27
9,102 reads
SQLSaturday #85 Orlando: Pragmatic Works BI Pre-Con!
I’m very proud to announce that Pragmatic Works will be presenting a Business Intelligence Workshop pre-con for SQLSaturday #85 in...
2011-07-27
688 reads
Strengths Finder 2.0
I’ve made the commitment to read and review 12 books over 12 months as a part of continuous personal development....
2011-07-27
894 reads
What is the hardest part of planning a SQL Saturday?
For me so far it has been the speaker selection. Getting sponsors didn’t prove to be difficult, we have a...
2011-07-27
522 reads
Fastest row counting method
SELECT COUNT(*) is most common method (and exact) how to find out how many records is in table. There is...
2011-07-26
6,375 reads
Leaked Information About AMD Opteron 6200 Series Processors
CPU World has a post about some leaked info regarding the upcoming Opteron 6200 series “Bulldozer” processor line. Here are...
2011-07-26
1,031 reads
My upcoming speaking engagements
A few days ago I had an interesting conversation on Twitter about my upcoming speaking
engagements. I really realized at this...
2011-07-26
785 reads
NYC SQL Server User Group - this Thursday - SQL2K8 Audit Feature
Quick update. This Thursday, July 28, 2011 at the NYC SQL Server User Group at Microsoft HQ in NYC, SQL MVP...
2011-07-26
1,461 reads
Optimize a query by thinking out of the box
Recently I had to create a simple query to lookup a single row in a table containing ranges that do...
2011-07-26
621 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