Calculating Age
T-SQL calculations can get tricky at times, and since you often work with multiple rows, it's good to be exact in your data manipulation. New author Lynn Pettis brings us an article about calculating ages.
Downtime
One thing most DBAs try to avoid whenever possible is unexpected downtime. It still happens, and we have to deal with it. This Friday Steve Jones asks in the poll how much it happens to you.
[Off-Topic] Eleven Year-Old Making a Difference
Those who know me personally know that I grow my hair out to donate for kids. I have donated a couple of times to Locks of Love . This past Saturday I participated in a hair collection drive led by 11 year-old Sarah Brotman: Midlands girl gets a haircut...
Is not encrypting personal info worth the risk?
Learn why choosing against the encryption of personal info in your SQL Server database can leave your organization vulnerable to certain compliance issues.
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.
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.
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.
SQL Server 2008 Service Pack 1 Released
Service Pack 1 for SQL Server 2008 has been released. Follow the link for more information.
Working with Amazon Simple DB
This article explores the concepts and methods necessary to create, manipulate, and work with Amazon Simple DB.
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers