SQL Date functions in SQL Server
SQL date format functions like the DateDiff SQL function and DateAdd SQL Function are oft used by DBAs but many...
2018-12-04
662 reads
Blog Posts
SQL in the City is Next Week
Next Wednesday, Dec 12, I’ll be back in the UK with Kathi, Kendra, and Grant for SQL in the City...
2018-12-04
801 reads
System Variables in Azure Data Factory: Your Everyday Toolbox
(2018-Nov-20) After working and testing the functionality of variables within Azure Data Factory pipelines, I realized that it's worth to explore...
2018-12-04 (first published: 2018-11-20)
2,856 reads
T-SQL Tuesday 109: Influence Somebody Invite
How have you impacted somebody in the community?
It has now been 28 months since the last time I hosted a...
2018-12-04
226 reads
T-SQL Tuesday 109: Influence Somebody Invite
Building on the work of these three fine individuals, here comes the difficult task. You have been the benefactor of some awesome help from somebody else. You even wrote...
2018-12-04
4 reads
Two Words For Faster Scalar Functions
Watch this week's video on YouTube
WITH SCHEMABINDING optimizations were added all the way back in SQL Server 2005. So why bother talking about them in 2018?
Because no one is...
2018-12-04
7 reads
Two Words For Faster Scalar Functions
Watch this week’s episode on YouTube.WITH SCHEMABINDING optimizations were added all the way back in SQL Server 2005. So why...
2018-12-04
230 reads
Two Words For Faster Scalar Functions
Watch this week's video on YouTube
WITH SCHEMABINDING optimizations were added all the way back in SQL Server 2005. So why bother talking about them in 2018?
Because no one is...
2018-12-04
18 reads
Advent of Code 2018 – Day 1 (Chronal Calibration)
Advent of Code
This guy by the name of Eric Wastl (t) created this neat web site called “Advent of Code“....
2018-12-03
305 reads
Epic Life Quest – looking back
This will be my last post for the year. In this am going to look back on goals I set...
2018-12-03
731 reads
Blogs
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers