Sweeping out SQL Server 2005
Tony Davis on why the dusty corners of many organizations still hide numerous SQL 2005 instances.
2015-04-20
161 reads
Editorial
Monitoring After Deployment
This Friday's poll looks at the time after deployment. Can you tell if things were successful? Do you have a formal way to determine if the changes are causing issues?
2019-06-04 (first published: 2015-04-17)
381 reads
QA for Data
Often DBAs and developers might make quick data changes to correct user problems or application shortfalls. Steve Jones notes that we can make mistakes, and perhaps we should ensure we QA, or at least log, our changes.
2015-04-16
154 reads
2018-06-26 (first published: 2015-04-14)
281 reads
Pre-built or Ad Hoc
Steve Jones talks about the ad hoc nature of some NoSQL databases and whether that's something that most users want.
2015-04-13
157 reads
Don't exaggerate the difficulties of the RDBMS
Phil Factor argues that in learning about relational databases such as SQL Server, we should encourage people to "break a few pots".
2015-04-13
162 reads
After Six Months On The Job What Challenges Remain?
Today we have a guest editorial from Andy Warren that asks what you might do when you get settled at a new job.
2018-06-19 (first published: 2015-04-10)
252 reads
State v Migrations
Steve Jones talks a bit about the difference between state based and migrations based approaches for deployment.
2018-06-18 (first published: 2015-04-09)
171 reads
Release Wednesday
One of the teams at Red Gate is releasing new changes every Wednesday, which reminds Steve Jones of a time earlier in his career.
2018-06-20 (first published: 2015-04-08)
111 reads
Kanban
Steve Jones talks about organizing and tracking work with kanban and how that might help you.
2015-04-07
331 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