Using Code Snippets in SSMS
Snippets will allow you to code faster by inserting chunks of code with few key strokes.
2018-08-17 (first published: 2016-04-07)
6,400 reads
Luis Cazares
SQL Server Rounding Tips and Tricks
This article shows different options to use the rounding functions in SQL Server.
2018-08-10 (first published: 2016-09-20)
8,501 reads
Wildcard Searches
Using wildcard to find patterns in strings going from the basics to some more complicated conditions.
2017-02-10 (first published: 2015-09-29)
15,353 reads
Introducing the Set-based Loop
Set-based programming doesn’t mean “no loops” or a single statement. Finding out the best ways to traverse a full hierarchy.
2016-10-07 (first published: 2015-07-27)
20,217 reads
2015-11-18 (first published: 2015-10-29)
744 reads
Calculating Working Hours
Calculating working hours can be painful due to all the variances that they imply. This function will calculate working hours between 2 dates which might include time. There's an option to use a holidays table that will vary in each environment.
2015-10-22 (first published: 2014-05-22)
3,616 reads
Blogs
Daily Coping 9 Apr 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Webinar: How to unlock the value of frequent deployments
By Steve Jones
I’m doing a webinar next week, on Wednesday, April 15, 2020, that looks at...
SSMS 18.5 Fixes from Redgate
By Steve Jones
I wrote yesterday about the issues with SSMS 18.5 and some of the add-ins...
Forums
ALWAYS On Setup problem
While configuring N1 and N2 Nodes connected to DC Domain Controller working fine. Establishing...
Do You Have a Mentor?
Comments posted to this topic are about the item Do You Have a Mentor?
Counting Rows in DAX
Comments posted to this topic are about the item Counting Rows in DAX
Ask SSC