Being More Productive
This Friday's poll looks at your productivity. Is there some technology that has really helped you do your job better?
2009-03-20
139 reads
Editorial
Secure Programming
Writing secure programs is hard. Steve Jones has a few comments on what some of the issues are with training developers.
2013-10-02 (first published: 2009-03-19)
509 reads
Guest Editorial: Short Transactions
It is ingrained in many developers and DBAs to keep transactions in SQL Server "as short as possible". Why does this mindset exist? Does it imply a deep-seated lack of confidence in the scalability of SQL Server's locking and concurrency models?
2009-03-18
175 reads
SQL Server Knockoffs
Will we see a low-cost SQL Server knock-off at some point? Steve Jones thinks it could happen as the RDBMS becomes a commodity product.
2013-10-29 (first published: 2009-03-17)
282 reads
Software Licensing Cuts - Database Weekly (Mar 16, 2009)
In the news this week, Microsoft is cutting some licensing costs for larger companies. A good move for them as the economy slows.
2009-03-16
78 reads
Letting People Go Securely
Having employees leave your company is a reality of life. But how do you handle letting your IT workers go and protect your systems? Steve Jones isn't sure there is much you can do to prevent issues, but you can deal with them.
2013-10-09 (first published: 2009-03-16)
358 reads
Keep It Simple
As we build more sophisticated maintenance procedures, we increase the complexity of our systems. Is that a good thing? Steve Jones has a few comments on what this means for DBAs.
2009-03-12
202 reads
Guest Editorial: Improving Northwind
The Northwind database has a place in our collective hearts, despite all efforts to displace it in favor of AdventureWorks. However, a lot has happened in the past twelve or so years, and Phil Factor wonders if we can't, as a community, do better.
2009-03-11
155 reads
The Challenges of Being Safe
Securing your data is a challenge. Steve Jones has a few comments no just how hard it can be to obfuscate your production data as you move it to development environments.
2020-06-24 (first published: 2009-03-10)
529 reads
What Does Support Look Like?
With a new version of SQL Server being released every 2-3 years now, what does that mean for support from Microsoft? What about from DBAs?
2009-03-09
133 reads
Blogs
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Forums
SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Cannot get KB959420
Hi, we lost our sever sql2000 To restore database to a new one we...
Do You Really Need HA?
Comments posted to this topic are about the item Do You Really Need HA?
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers