Spider-Man Homecoming Twitter Sentiment
Hello Dear Reader! This past Thursday night I took my son Zachary to see Spider-Man Homecoming, it was an amazing...
2017-07-10
361 reads
How to analyze SQL Server database performance using T-SQL
The performance of a database is the most challenging and critical part of database optimization. The challenge every DBA faces...
2017-07-10
467 reads
I’m Hosting! Idera July #sqlchat
Have you heard of these following terms and/or phrases?
Database Continuous DeliveryDatabase Lifecycle Management (DLM)DevOps[Insert other buzzword bingo entry here]You probably...
2017-07-10
122 reads
I’m Hosting! Idera July #sqlchat
Have you heard of these following terms and/or phrases?
Database Continuous DeliveryDatabase Lifecycle Management (DLM)DevOps[Insert other buzzword bingo entry here]You probably...
2017-07-10
282 reads
Running SSIS in an Azure VM
In the previous post in this series, I addressed how to use an on-premises instance of SSIS to move data...
2017-07-10
1,005 reads
The Choices We Make
If you keep your head up and look around you’ll see the choices people make all the time. I saw...
2017-07-21 (first published: 2017-07-10)
1,978 reads
Self-Paced Online Trainings
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-07-10
249 reads
Monday Coffee: Database Deployments
I’ve always been particularly cautious when it comes to deploying code to databases, some would say overly cautious.
Because of this...
2017-07-10
727 reads
Add new articles to existing Transactional Replication without initializing old articles
Suppose, you have Transactional Replication configured in your production environment. There is a business requirement to add a new article to the...
2017-07-20 (first published: 2017-07-10)
12,163 reads
Bash on Windows
With SQL Server coming on Linux, some people will want to learn a bit of Linux. Or perhaps they need...
2017-07-07
1,025 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