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
54 reads
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
470 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,667 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,380 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
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Practical SQL Server Development Tips for Better Database Projects
Working with SQL Server 2022 can be a great learning experience, but development tasks...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers