Be Careful! Backups Can Bite You!
Here is a riddle for you…
You are requested to move a database from an old server to a new server....
2014-10-24 (first published: 2014-10-20)
7,595 reads
Blog Posts
Find all triggers in a SQL Server Database
Reading Time: 2 minutes
What Are Database Triggers?
Do you know what triggers lurk in your database?
Triggers can be implemented to enforce...
2014-10-24
514 reads
Overview of Published Articles – 2014Q3
Here is an overview of the articles I published in the third quarter of 2014.
INTENSE SCHOOL
MCSE Prep (SQL) – Using Parameters...
2014-10-24
783 reads
Reblog: October 17 to October 23
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-10-24
787 reads
Clustered Columnstore Indexes – part 42 (“Materialisation”)
Continuation from the previous 41 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Important Disclaimer – I have started writing this blog post over 1 months...
2014-10-23
344 reads
Untrusted Foreign Keys
What is a Foreign Key?
Do you trust your foreign keys?
A foreign key is a link between 2 tables that is...
2014-10-23 (first published: 2014-10-17)
7,692 reads
Database Ghosts
Recently you may have seen my first article on this topic over at SQL Solutions Group. If not, here is the link so you can read that article first...
2014-10-22
6 reads
Networking at the PASS Summit
The 2014 PASS Summit is coming up in a few weeks and thousands of SQL Server professionals will be coming...
2014-10-22 (first published: 2014-10-15)
6,572 reads
Off to London
Today I’m off across the Atlantic again. SQL in the City 2014 kicks off in London and I have 3...
2014-10-22
998 reads
What collation variables take on in T-SQL
I was asked an interesting question about collations in sql server recently about where variables in a script got their...
2014-10-22
55 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...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
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