Finding the Right Path
I have a fairly large backlog of articles that are in progress or that are planned for my series about...
2016-09-05 (first published: 2016-08-24)
1,488 reads
Blog Posts
October precon in Orlando: “The Lifecycle Approach: Maintenance Problems & Solutions”
On October 7 we will be presenting a full day of maintenance and backup learnin’! Register here: https://www.eventbrite.com/e/sql-saturday-564-the-lifecycle-approach-maintenance-problems-solutions-tickets-26867268724 And while you’re at...
2016-09-05
474 reads
SPACE
USE CASE: When we are working on TSQL or some text based scripting we may need some extra space in between...
2016-09-04
194 reads
STUFF
Use case when we are working on TSQL or Query ,some time we came such a situation when we need...
2016-09-04
189 reads
Why Would I Want to Use JSON in SQL Server?
SQL Server 2016 offers built-in support for JSON, in a similar way to the support offered for XML since SQL...
2016-09-04
647 reads
DAX Date Dimension and Fun with Date Math
I was working on a SSAS Tabular 2016 solution for a project for which I had no data (an empty...
2016-09-03
653 reads
How to Resume Suspended Database Mirroring in SQL Server ?
Overview
Database mirroring is a feature in SQL Server which is creating and maintaining the redundant copies of the database. The purpose behind database mirroring is continuous data availability and...
2016-09-03
102 reads
How I Got Here: Microsoft
Here we are, 7 years working with SQL Server and Microsoft BI tools. Sure in the grand scheme of things...
2016-09-02 (first published: 2016-08-23)
2,107 reads
SQLMonitor Adds Graphical Query Plans!
The SQLMonitor team at Redgate has been releasing updates at a much more rapid rate…what’s this mean to you? More fixes and more features. In this latest release, they...
2016-09-02
13 reads
SQLMonitor Adds Graphical Query Plans!
The SQLMonitor team at Redgate has been releasing updates at a much more rapid rate…what’s this mean to you? More...
2016-09-02
480 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers