Offer – Any e-book for $5
Packt Publishing are having a price drop bonanza over the Christmas period. You can get any e-book for just $5...
2014-12-19
479 reads
Blog Posts
Quick Audio Switching
I’ve got a semi complicated desktop setup, with multiple monitors, lots of USB stuff, and a few ways to record...
2014-12-19
890 reads
Reblog: December 12 to December 18
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-12-19
889 reads
SQL #55 – Data Types and Storage Reference
When we design a database, we usually need to do an estimate on the size of the database based on the...
2014-12-19
1,088 reads
Whats New 2014
Hey all, Continue to my whats New series, I am going through its new features and the more I am...
2014-12-19
573 reads
XQuery - Accessing the Attributes Axis
Working with a sequence of attributes in XQuery is fairly straight forward with the 'attribute' axis even if you don't...
2014-12-19
842 reads
Conferences & Presentations of 2014 in Review
Reviewing the year 2014, I can see that I have truly started improving my life by lowering the number of...
2014-12-18
426 reads
Nominated for the 2014 Tribal Awards
Just like last year, SQLServerCentral.com and Simple Talk are hosting the Tribal Awards. In their words:
The Tribal Awards, co-hosted by Simple-Talk and...
2014-12-18
853 reads
PASS – Connect, Share and Learn
The Professional Association of SQL Server (PASS) has a slogan for what they do – CONNECT, SHARE and LEARN. So, what...
2014-12-18
624 reads
T-SQL Tricks – Trigger Your Memory
I was scanning Twitter the other day and saw a note from someone that they had written a query using...
2014-12-18 (first published: 2014-12-11)
7,878 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