Archiving
It seems that archival isn't on the mind of most designers when they first build a database, which is OK, but DBAs ought to be building skills to implement this if the data size grows large.
2011-06-20
743 reads
Editorials
Patch Week
This week Steve Jones notes there were quite a few patches from Microsoft for a variety of products. No SQL Server specific security patches, but that doesn't mean that DBAs shouldn't be patching systems.
2011-06-20
137 reads
Multiple Failures
This Friday Steve Jones has a disaster recovery poll. When you have a true disaster, often there are multiple things that go wrong and cause a cascading failure. Is this common, let us know what your experience is this Friday.
2011-06-17
117 reads
Phrases that Resonate
Today we have a guest editorial from Andy Warren. Are there particular phrases that you use in technology that resonate with you and have particular meanings? Andy shares a few of his favorites.
2011-06-16
157 reads
Understanding Security
It is important for data professionals to understand security, but it's also important for end users that must handle data. However we have a lot of work to do to make that easier since Steve Jones thinks many IT pros struggle with this concept.
2011-06-15
286 reads
Etiquette
As technology has rapidly advanced our communications, we have not necessarily learned to deal with the implications and challenges of this anywhere, anytime communication reach. Steve Jones reminds us that etiquette matters, even when we are designing systems.
2011-06-14
221 reads
Cloud Outages
It seems that we regularly hear about outages from various cloud services. Steve Jones comments that we are likely to have this happen more and more, but it's shouldn't happen at a rate greater than in house IT services.
2011-06-13
155 reads
What's holding you back?
If you’re not where you want to be in your career, then what do you think is holding you back?
2011-06-13
221 reads
The Desire for Control
This Friday Steve Jones asks you if you want more knobs for SQL Server or less? It's a debate that balances the need for the DBA to know more with the resources Microsoft spends to build better tuning into the product.
2011-06-10
102 reads
Economics
Today we have an editorial from Mar 22, 2006 as Steve is on vacation. Today Steve Jones notes that economics might determine how you are paid, but human nature describes how you behave.
2011-06-07
119 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers