Check Constraints can help enforce the all or nothing approach when it comes to column updates
If you have a set of columns inside your table that you want to allow nulls in, however if one...
2013-07-18
1,236 reads
Fixing Bad Links Found Using Google Webmaster Tools
I’ve been doing various clean up tasks this week related to the blog, with part of that being a review...
2013-07-18
827 reads
SQLSaturday#235 NYC - The Schedule You All Have Been Waiting For!
Late last night in the
Halls of Congress, a grand gathering of planners took place to form that
which we...
2013-07-19 (first published: 2013-07-18)
1,714 reads
70-457 Reviewer #04, Implement a Migration Strategy
Upgrading an instance is a process in which you upgrade an existing instance of SQL Server to SQL Server 2012....
2013-07-18
591 reads
SQL Server: Performance Tuning :Understanding Set Statistics Time output
In the last post we have discussed about Set Statistics IO and how it will help us in the performance tuning. In this post we will discuss about the Set...
2013-07-18
85 reads
Amusing SQL Trick – Hide yourself from SQL Server
I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead...
2013-07-17
840 reads
PASS Security Virtual Chapter & Security Topics at PASS Summit
I just saw a post from Brian Kelley about the new PASS Security Virtual Chapter launching and the first presentation...
2013-07-17
604 reads
SQL Server: Performance Tuning :Understanding Set Statistics Time output
In the last post we have discussed about Set Statistics IO and how it will help us in the performance tuning....
2013-07-17
19,714 reads
The Stairway to Deployment
Next week I travel to Sacramento, CA for the SQL in the City Seminar – Stairway to Deployment on Friday, July...
2013-07-17
1,080 reads
Disable the Charms Bar – Making Windows 8 Better
One of the things that’s bothered me is the way the charms bar frequent popping out as my mouse moves...
2013-07-17
966 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...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
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