Combining statement with conditional operators
Operators “AND”, “OR”Sometime we need to combine two or more TSQL statement based on some conditions, that we can achieve...
2016-12-12
254 reads
Blog Posts
Database synchronization in the Software Development Life Cycle
Reading the title, most of you are probably thinking: What does database synchronization have to do with the Software Development...
2016-12-12
830 reads
Database synchronization in the Software Development Life Cycle
Reading the title, most of you are probably thinking: What does database synchronization have to do with the Software Development Life Cycle (SDLC)? Stick around, because I'll get to...
2016-12-12
20 reads
How to use DTA (Database Tuning Advisor) with Plan Cache option?
SQL Server 2012 comes up with new workload option in DTA (Database Tuning Advisor). In addition, on existing options File...
2016-12-12
2,669 reads
I use Elastic database pools – for now
When you have many SQL databases that are required to run your environments and they show signs of specific usage...
2016-12-12 (first published: 2016-12-02)
1,444 reads
Manual v Automation
I’ve got my work cut out for me. This week is SQL in the City 2017. One of the sessions...
2016-12-12
497 reads
Monday Coffee 2016-12-12
Speaking and presenting
One of my biggest fears is public speaking and judging by this article, I’m not alone.
However it’s something...
2016-12-12
299 reads
OPTIMIZE FOR Hints When Parameter Sniffing is Turned Off
While presenting recently and talking about dealing with bad Parameter Sniffing, I got the question; what happens to OPTIMIZE FOR...
2016-12-12
642 reads
SQL Server DBA Tips that Can Save Your Ass
On November 9th I presented a session in the PASS Database Administration Virtual Chapter. The title of the session was...
2016-12-12
386 reads
SQLBits 2017 In April
I’m getting excited, with the announcement that SQL Bits 2017 is scheduled. The conference goes back to Telford, which I...
2016-12-12
532 reads
Blogs
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...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
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