SQL Server Table Partition Example
Why Use a SQL Server Table Partition
Data warehouses and data repositories often have tables that store millions of records and...
2014-11-03
5,168 reads
Blog Posts
SQLPASS Summit 2014 is here, The largest SQLServer Conference !
November is not the right time to visit Seattle (Blame the rain!), but I kinda like November because that’s when...
2014-11-03
538 reads
What is a data warehouse and why do I need one?
While the data warehouse isn’t a new concept, many are left wondering – what is a data warehouse? And why do I need one? I’m sad to tell you...
2014-11-03
12 reads
Bon Voyage fellow PASS Summit 2014 Attendees!
For the first time ever, I will be a PASS Summit Attendee! I’m very excited about going and I’ll be...
2014-11-02
472 reads
How I Got Here: 5 Years At Pragmatic Works
I recently celebrated my 5 year anniversary at Pragmatic Works. Boy, how time flies by. It feels like just the...
2014-11-02
1,651 reads
Non use of persisted data – Part Three
A long time ago I looked at some reasons as to why persisted computed columns ( and therefore indexes on those...
2014-11-02
363 reads
PASS Summit 2014 Diary – Day 0
This week, I’m attending two different summit events in the Seattle area. On Sunday through Tuesday, I’ll be participating in...
2014-11-02
753 reads
Unit tests help document your code!
I recently had the chance honour to spend twenty minutes talking to Boris Hristov about testing with Sql Server for...
2014-11-02
46 reads
Unit tests help document your code!
I recently had the chance honour to spend twenty minutes talking to Boris Hristov about testing with Sql Server for his Google Hangouts series, catch the video here
One of...
2014-11-02
4 reads
Unit tests help document your code!
I recently had the chance honour to spend twenty minutes talking to Boris Hristov about testing with Sql Server for...
2014-11-02
62 reads
Blogs
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 ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
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...
How Accounting Assignment Help Improved My Academic Performance
I recently used accounting assignment help, and it made a huge difference in my...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers