Reverse It
Recently I had a conversation with a colleague that wasn’t aware of the REVERSE function in SQL Server. I had...
2017-06-06
143 reads
John Morehouse | Sqlrus.com
Ola Hallengren: Output File
I’m a huge fan of Ola Hallengren‘s free utility scripts. If you aren’t familiar with it, it’s a great tool to...
2017-06-12 (first published: 2017-05-30)
3,916 reads
Ola Hallengren: Output File
I’m a huge fan of Ola Hallengren‘s free utility scripts. If you aren’t familiar with it, it’s a great tool to...
2017-05-30
364 reads
Experienced DBA: Rookie Mistake
M.A.S.H 4077. Mobile Army Surgical Hospital. One of my all time favorite TV shows that I still watch to this...
2017-06-05 (first published: 2017-05-23)
2,402 reads
Experienced DBA: Rookie Mistake
M.A.S.H 4077. Mobile Army Surgical Hospital. One of my all time favorite TV shows that I still watch to this...
2017-05-23
113 reads
Knowing the Options
Have you every executed a query in SQL Server Management Studio, looked at the execution plan, and noticed that it...
2017-05-16
407 reads
T-SQL Tuesday #90 – The Elephant’s Name is Database
T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community It is the brainchild of Adam Machanic (B|T)...
2017-05-25 (first published: 2017-05-09)
2,077 reads
I’m Speaking! SQL Saturday #617 – Pensacola
In early June, I’ll be traveling to Pensacola, Florida for their annual SQL Saturday. This will be my second time...
2017-05-02
325 reads
SSIS – Adding Connections
Sometimes you get reminded that you don’t know everything about SQL Server and it’s various products Every time I run...
2017-04-27
568 reads
Quick Script: Finding Specific Columns
I like scripts. Scripts that help me do things.
Working in the financial industry, there are always things that you have...
2017-05-04 (first published: 2017-04-25)
1,471 reads
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers