Moving The Bottleneck
Most of you probably get that there will always be a bottleneck in a system. You implement a fix in...
2013-07-24
580 reads
24 Hours of Education
You absolutely need to learn more. I need to learn more (lots more). We all should be constantly learning more...
2013-07-24
569 reads
I’m going to my first SQL Saturday!
I got to go to the Pass Summit in 2011 and had a fantastic time despite some travel issues caused...
2013-07-24
665 reads
SQL Saturday Sacramento This Weekend
SQL Saturday #222 in Sacramento, CA, is coming fast! This Saturday, July 27, I will be presenting a little pre-show...
2013-07-24
671 reads
Understanding Contained Database in SQL Server 2012
SQL Server 2012 supports contained databases and partially contained databases, which provide a high degree of isolation from the database...
2013-07-24
1,249 reads
70-457 Reviewer #06, Configuring and Managing Database in SQL Server 2012
DBAs are most responsible for configuring and managing of database infrastructure, database file locations, database encryption which do not have...
2013-07-24
655 reads
SQL Server : Understanding Differential Change Map (DCM) Page and Differential Backups
In our earlier posts, we have discussed about different types of pages.Data Pages, GAM and SGAM,PFS page and IAM page. In this post, we will try to understand the Differential Change...
2013-07-24
1,815 reads
SQL Server 2008 Service Pack 3 CU12
On July 15, Microsoft released SQL Server 2008 Service Pack 3 Cumulative Update 12, which is Build 10.0.5844. I count...
2013-07-23
711 reads
SQL Server 2012 Service Pack 1 CU5
On July 15, Microsoft released SQL Server 2012 Service Pack 1 Cumulative Update 5. This is Build 11.0.3373, and I...
2013-07-23
1,494 reads
Gap issue in SQL Server 2012 IDENTITY column
Found a gap issue when using IDENTITY column in SQL Server 2012, every time I restarted sql server service, the current...
2013-07-23
3,761 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