Skip to Content

T-SQL Posts

PASS SQL Saturday #687 Slovenia 2017

Posted July 11, 2017

By

Here we go for the fifth time! The leading event dedicated to Microsoft SQL Server in Slovenia, PASS SQL Saturday #687, will take place on Saturday, December... more »
0

T-SQL Window Functions

Posted July 10, 2017

By

I’ll soon post something on this, but let me tell you right here. If you don’t want AI to take you DEV/DBA/BI job you *need* to be smarter than AI (which... more »
0

How to calculate barcode check-digit using T-SQL language

Posted June 23, 2017

By

Introduction In order to scale, it’s imperative that companies stay ahead of competition. So how can they identify, store, manage and deliver goods to... more »
0

Utility to temporarily drop FOREIGN KEY constraints on a set of tables

Posted June 15, 2017

By

I was working on a database a few weeks back (maybe longer, I am kind of busy with several projects right now), and I wanted to truncate a set of tables. There... more »
2

Utility to script a FOREIGN KEY Constraint

Posted May 24, 2017

By

Note: Amended to include the word include in the first Note (I am a terrible editor of my own writing!) and to fix a bug in the code with a misplaced... more »
0

Creating FOREIGN KEY constraints as enabled, trusted, non-trusted, and/or disabled

Posted May 07, 2017

By

I am in the middle of building a utility (for work, and for my next SQLBLOG post), that will help when you need to drop the foreign key constraints on a table,... more »
3

Quick Regions in SQL Server Management Studio (SSMS)

Posted April 14, 2017

By

There are a few tools and add-ins that support the creation of “regions” in T-SQL code. SQL Server Management Studio (SSMS) supports one way to separate... more »
0

SQL Server 2016 Developer’s Guide

Posted March 03, 2017

By

I can proudly announce that it is already possible to preorder the SQL Server 2016 Developer’s Guide book... more »
0

A new (to me, and possibly you) SSMS feature – Query Plan Comparing

Posted January 26, 2017

By

Wow, Microsoft has really changed in culture recently. This new rapid release cycle for SSMS is seemingly paying dividends in a major way. In a recent build of... more »
2

A new (to me, and possibly you) SSMS feature – Query Plan Comparing

Posted January 26, 2017

By

Wow, Microsoft has really changed in culture recently. This new rapid release cycle for SSMS is seemingly paying dividends in a major way. In a recent build of... more »
2