The Curse of Relational Databases
Let’s face it, none of Information Technology is easy. Oh yeah, there are those few geniuses that have an absolute...
2014-06-23 (first published: 2014-06-18)
5,178 reads
The Scary DBA
Natively Compiled Procedures and Bad Execution Plans
I’ve been exploring how natively compiled procedures are portrayed within execution plans. There have been two previous posts on the...
2014-06-17
1,361 reads
Differences In Native Compiled Procedures Execution Plans
All the wonderful functionality that in-memory tables and natively compiled procedures provide in SQL Server 2014 is pretty cool. But,...
2014-06-13 (first published: 2014-06-10)
2,062 reads
Speaker of the Month, June 2014
It’s not like I can’t find plenty of great presentations here in the US, but, while I was over in...
2014-06-06
753 reads
Natively Compiled Procedures and Execution Plans
The combination of in-memory tables and natively compiled procedures in SQL Server 2014 makes for some seriously screaming fast performance....
2014-06-05
1,368 reads
Add an Instance to SQL Server Azure Virtual Machine
How do you add an instance to your local SQL Server installation? You run the executable that you probably downloaded...
2014-05-19 (first published: 2014-05-13)
1,490 reads
Carolina Cruise
I’m going to speak at three user groups in three days in North and South Carolina. Evidently this is known...
2014-05-09
495 reads
Speaker of the Month, May 2014
Whoa! Another month gone by already? I guess I better pick a speaker of the month then. I went to...
2014-05-02
1,200 reads
Azure Automation
I introduced Azure Automation in a previous post. I’ve spent some more time exploring it.
There’s a set of documentation available...
2014-04-23
1,381 reads
I Am Better Than You
That is a patently false statement and total BS. It sure does crawl up your spine though doesn’t it? Why...
2014-04-22
934 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