Run For the PASS Board
When the word comes around for elections to the PASS Board, are you one of those people who, even in...
2016-08-22
424 reads
The Scary DBA
Updates to Azure Data Platform Learning Resources
I’m acting as the curator to a list of Azure Data Platform Learning Resources. It’s speakers and teachers, blogs, articles...
2016-08-17
517 reads
Query Store, Force Plan and Dropped Objects
I love the Query Store. Seriously. It’s a huge leap forward in the capabilities of Azure SQL Database and SQL...
2016-08-23 (first published: 2016-08-15)
1,810 reads
Azure SQL Database For Your First Database
This is post 8 supporting Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
In post #6, I talked about...
2016-08-15 (first published: 2016-08-09)
1,465 reads
There Is No Difference Between Table Variables, Temporary Tables and Common Table Expressions
I actually saw the above statement posted online. The person making the claim further stated that choosing between these three constructs was “personal...
2016-08-01
1,407 reads
Monitor Query Performance
Blog post #7 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here.
Sooner or later when you’re working...
2016-07-28 (first published: 2016-07-25)
2,628 reads
Common Table Expression, Just a Name
The Common Table Expression (CTE) is a great tool in T-SQL. The CTE provides a mechanism to define a query that...
2016-07-21 (first published: 2016-07-18)
3,606 reads
Same Query, Different Servers, Different Performance. Now What?
Based on the number of times I see this question on forums, it must be occurring all the time. You...
2016-07-19 (first published: 2016-07-11)
2,430 reads
Carpenters vs. DBAs
Let’s get the caveat out of the way up front, I work for a tool vendor.
If you look around at...
2016-07-05
1,240 reads
CASE Statement in GROUP BY
Set based operations means you should put everything into a single statement, right?
Well, not really. People seem to think that...
2016-07-06 (first published: 2016-06-28)
4,852 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