@LearningTree: SQL Server High Availability
Learning Tree are offering their 3 day SQL Server High Availability course this April in London. Running between 17th and...
2013-03-28
1,473 reads
SQLTreeo – Migration of extended properties to local storage
New SQLTreeo version introduced local storage option when your folders are stored to file system as structure of files and...
2013-03-28
1,687 reads
Network Packet Size: to Fiddle With or Not to Fiddle With
A network pipeline isn’t nearly as pleasant to look at as the oil pipeline (or anything) in Alaska, but it’s...
2013-03-27
3,275 reads
The DBA Team #1–Code and Slides
Our first DBA Team event, in Richmond, VA just before SQL Saturday #187 went well. Overall I think our experiment...
2013-03-27
1,652 reads
XQuery
In 2005 version of SQL Server, XQuerying was introduced. It’s a powerful feature and when used together with a CTE,...
2013-03-27
231 reads
What to Do When You Can't Wipe an Infected System
When it comes to workstations within most organizations, the solution when one gets infected is to wipe it and re-image...
2013-03-27
2,669 reads
Six top SQL Server 2012 management tools you should know about
Management tools play a vital role in enterprise database management. This is because the well-integrated tools extend the administrator’s capabilities,...
2013-03-26
1,466 reads
SQL Server: Purging msdb History Tables to Control msdb Database Growth
From time to time, I see the following question posted on various SQL Server forums by different users asking why...
2013-03-26
1,552 reads
XML Support and SQL Server (Part 5)
Checkout the fifth part of my XML support and SQL Server article series here.
In this article, I discussed the basic...
2013-03-26
635 reads
A Rickety Stairway to SQL Server Data Mining, Part 10.2: DMX DML
by Steve Bolton
The three introductory posts in this series of self-tutorials on SQL Server Data Mining (SSDM) and the...
2013-03-26
2,230 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