Variables in Dynamic SQL
I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement....
2017-11-16
1,500 reads
SQL Smackdown!!! Cursors VS Loops
Ladies and Gentlemen, welcome to the main event of the evening. The SQL Undercover Smackdown Heavy Weight Championship of the...
2017-11-16
2,521 reads
Write Your first Pester Test Today
I was in Glasgow this Friday enjoying the fantastic hospitality of the Glasgow SQL User Group@SQLGlasgow and presenting sessions with Andre...
2017-11-16
453 reads
You have your database in source control now what?
This post is for a specific type of person if you are:
New to source controlAre getting started on your path...
2017-11-16
364 reads
You have your database in source control now what?
This post is for a specific type of person if you are:
New to source control Are getting started on your path to the continuous delivery nirvana Have been...
2017-11-16
11 reads
You have your database in source control now what?
This post is for a specific type of person if you are:
New to source control Are getting started on...
2017-11-16
41 reads
You have your database in source control now what?
This post is for a specific type of person if you are:
New to source control Are getting started on...
2017-11-16
40 reads
How To Enlarge Your Columns With No Downtime
Let’s face it: column enlargement is a very sensitive topic. I get thousands of emails every month on this particular...
2017-11-15
965 reads
Microsoft Connect(); announcements
Microsoft Connect(); is a developer event from Nov 15-17, where plenty of announcements are made. Here is a summary of the data...
2017-11-15
87 reads
Microsoft Connect(); announcements
Microsoft Connect(); is a developer event from Nov 15-17, where plenty of announcements are made. Here is a summary of the data...
2017-11-15
544 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