Getting Organized
As DBAs we should be very detail oriented, but Steve Jones talks about some challenges with keeping up with your tasks and projects and some software that might help.
Microsoft DPM
This is a product that we have not heard much about, but Microsoft has a Data Protection Manager, designed to help ensure you can recover your databases by centralizing your backup files. Author Jay Dave brings us a short overview on this product.
Using Reporting Services to Search the SQL Server Log
A unique solution that allows Reporting Services to easily publish information from your SQL Server Error logs.
Recognizing Talent
Microsoft made a sizeable big for Yahoo and Steve Jones talks about one of the more interesting aspects of that bid that didn't receive much press.
Recognizing Talent
Microsoft made a sizeable big for Yahoo and Steve Jones talks about one of the more interesting aspects of that bid that didn't receive much press.
Recognizing Talent
Microsoft made a sizeable big for Yahoo and Steve Jones talks about one of the more interesting aspects of that bid that didn't receive much press.
Simplify SQL Server 2005 queries with a Dates table
Learn what a Dates table is and how to create one, and then try it out for yourself
SQL Server source code analysis and management adds database security
SQL Server source code analysis and management add database security by debugging and testing SQL applications. Learn about SQL source code analysis.
Database Weekly - May 5, 2008
A look back at the news of the past week dealing with SQL Injection, slow SQL Server growth and two level security.
The Dedicated Administrator Connection
New to SQL Server 2005 is the Dedicated Administrator Connection (DAC), which provides a way to ensure you can always connect to your server. No more getting locked out of a busy server as could occur in prior versions. Wayne Fillis brings us a short tutorial on this handy new feature.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Alamat kantor resmi BCA KCU BOGOR Telp: 0817.82.5533
WhatsApp: 0817825533, Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor,...
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
BCA KCP RADEN SALEH TLP/WA 083800119009
Jl. Raden Saleh No. 13, 15, 17A, Daerah Khusus Ibukota Jakarta 10430
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers