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
793 reads
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
515 reads
Find all triggers in a SQL Server Database
What Are Database Triggers?
Do you know what triggers lurk in your database?
Triggers can be implemented to enforce business rules or...
2014-11-05 (first published: 2014-10-24)
25,380 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
785 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
351 reads
Writing Fair and Useful Editorial Reviews Is Hard Work
One of my original goals was to be more reporter than editorial writer, but I’ve found that the editorial part...
2014-10-31 (first published: 2014-10-23)
5,646 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
8 reads
Database Ghosts
Recently you may have seen my first article on this topic over at SQL Solutions Group. If not, here is...
2014-11-04 (first published: 2014-10-22)
7,090 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
43 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
67 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers