Database Design Guidelines For Developers
One of the developers that I work with asked me to write a “brief” (really brief) guide on database design....
2014-04-07 (first published: 2014-04-03)
25,830 reads
Blog Posts
Decode SQL Server Job Schedules
As once a data architect, I cannot help but admiring and appreciating the data model behind the sql server job...
2014-04-07
1,546 reads
Decree: Set your partition offset and block size – make SQL Server faster
If I’ve said it once, I’ve said it 1,024 times: your SQL data and log drives need a 1024 KB...
2014-04-07
1,494 reads
I'm Speaking at SQL Saturday Houston, May 10th.
I will be speaking at my first SQL Saturday. I'll be in Houston May 10th. I'm rather surprised to be...
2014-04-07
573 reads
Last Weeks Top “Reading” Links #78
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-04-07
689 reads
SQL Saturday Exeter
A couple weeks back was the second SQL Saturday to be held in Exeter. Although I wasn’t speaking this time,...
2014-04-07
575 reads
SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio
By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...
2014-04-07
311 reads
SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio
By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...
2014-04-07
497 reads
SQL Server licensing consideration
You might already read lots of post about SQL server 2012 is license per core rather then per socket and...
2014-04-07
515 reads
SSIS XML Task
The XML Task in SSIS allows you to parse through an XML file and read the nodes in the XML....
2014-04-07
430 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