Testing a Birthday Month Query
I ran across a post from a tester, wondering how to write a query for birthday months. This makes sense,...
2017-12-15 (first published: 2017-12-04)
1,939 reads
Why I Use AdventureWorks for Demos
I know that when some people see AdventureWorks, their vision turns all red around the edges, their blood pressure spikes...
2017-12-04
377 reads
An introduction to a SQL Server 2017 Graph database
What is a graph database?
A graph is composed of two elements: a NODE (vertices) and an EDGE (relationship). Each node...
2017-12-04
802 reads
SQL Homework – December 2017 – View the log
Last homework of the year. Last month was to create a view. This month it’s time to take a look...
2017-12-04
317 reads
Configure Always on AG with SQL 2017
One of the new features that we have with SQL 2017 is that you no longer need a Windows cluster to enable the AlwaysOn feature with SQL server (remember...
2017-12-04
50 reads
T-SQL Tuesday #97 – Setting learning goals for 2018
This is my first opportunity hosting a T-SQL Tuesday and am super excited!!T-SQL Tuesday is the brainchild of well respected SQL Guru...
2017-12-04
954 reads
Book Review – The Biml Book
After years of waiting, a book about Biml has been published! It’s conveniently titled “The Biml Book” (subtitled Business Intelligence and...
2017-12-04
884 reads
The Myth Of Tomorrow
“We’ll fix it in the mix.”
“It’s good enough for right now.”
“We’ll worry about that later.”
“Your check is in the mail.”
Of...
2017-12-04
736 reads
Configure Always on AG with SQL 2017
One of the new features that we have with SQL 2017 is that you no longer need a Windows cluster...
2017-12-04
24,957 reads
System.ConsoleColor error while running powershell in SQL agent job step
Issue: While running powershell in SQL agent job step, I am getting below error: –
A job step received an error...
2017-12-04
998 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...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
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