The ‘addicted to data’ decade is still in its infancy
“Content is king” is the golden rule of the SEO. The semantic web is all about data. Any web or traditional application has no value without data. Few people...
2010-06-25
5 reads
Blog Posts
The ‘addicted to data’ decade is still in its infancy
“Content is king” is the golden rule of the SEO. The semantic web is all about data. Any web...
2010-06-25
12 reads
The Exceptional DBA of 2010
I’ve been a judge in this contest for the last 3 years, and each years we’ve had really good finalists,...
2010-06-25
816 reads
What Has Jack Been Up to?
It has been awhile since my last post mainly because I was on a working vacation in northern New England...
2010-06-25
454 reads
Building a PASS Voting Solution – Part 6
Today we’ll try to finish up by looking at a couple of the semi-interesting parts of the code in this...
2010-06-24
642 reads
Guest Editorial on SSC – Selling Used Cars/Experience Requires Repetition
I’ve been experimenting with stories in the editorial, experiences of my own that are amusing and have some kind of...
2010-06-24
934 reads
MDX webinar
Today I did a webinar on MDX solutions. For those of you interested you can grab the slides here and...
2010-06-24
1,213 reads
My SELECT statement has hung!
One of the first roadblocks many developers run into when using SQL Server for the first time is firing off...
2010-06-24
2,581 reads
PASS Board Call For Nominations Open
Nominations opened today and will run through July 21st. Whether you’re planning to be a candidate or not, I hope...
2010-06-24
553 reads
PowerShell Script to Remove Old Backups
A Twitter user asked for a script to remove old backups, and I had one I built back in February,...
2010-06-24
1,125 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