SQL Server 2012 Business Intelligence Enhancements
My first article in SQL Server Pro magazine has been published. It is entitled “SQL Server 2012 Business Intelligence Enhancements”...
2013-03-28
1,570 reads
Security: People Are the Weakest Link
There was an interesting conversation on Twitter today about security awareness and why the training so often fails. From my perspective, here's...
2013-04-05 (first published: 2013-03-28)
3,330 reads
@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,688 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
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