Running tSQLt tests from C/VB.Net/Java/Whatever
When you already have a test framework setup such as MSTest or NUnit and possibly a CI build in place...
2014-11-20
66 reads
Clustered Columnstore Indexes – part 43 (“Transaction Log Basics”)
Continuation from the previous 42 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This post is dedicated to the Transaction Log behaviour, which might explain...
2014-11-19
426 reads
SQL Konference 2015
My first speaking date of the new year is scheduled. I’ll be at the SQL Server Konference 2015, near Frankfurt,...
2014-11-19
869 reads
How to determine Meta data or result set information of a stored procedure /trigger ? TIP # 73
Sometimes it may require that you don’t know what will be output of a stored procedure ? what kind of result...
2014-11-19
471 reads
T-SQL Tricks – Custom Templates
I wrote about the Template Explorer, which comes with the SQL Server tools and is visible in Management Studio (SSMS)....
2014-11-25 (first published: 2014-11-19)
8,350 reads
Fast Track Data Warehouse Reference Architecture for SQL Server 2014
I have previously blogged about the Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see Microsoft SQL Server...
2014-11-19
1,623 reads
You don’t really need ORDER BY do you?
You see dozens of blog posts and articles about how the order of a result set is not guaranteed without...
2014-12-01 (first published: 2014-11-19)
9,668 reads
SOA and message based integration - the challenge of bulk data changes
I'm working on problems of enterprise data integration in the role of enterprise architect, but I am and have been...
2014-11-24 (first published: 2014-11-19)
6,383 reads
For better Sql code use fake tables
When unit testing code there is a really powerful feature that is either called mocking or faking or sometimes using stubs and what these mean is creating objects that...
2014-11-18
19 reads
For better Sql code use fake tables
When unit testing code there is a really powerful feature that is either called mocking or faking or sometimes using...
2014-11-18
51 reads
Blogs
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...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
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