Getting More Hardware Information from SQL Server Denali DMV Queries
As I recently discussed, I often hear from database professionals who are not allowed to access their database servers directly....
2011-04-08
1,487 reads
Blogs
Am I a sysadmin? (or other SQL Server role)
How do you check if you are a sysadmin? It’s fairly easy to do in Management Studio. You can go...
2011-04-08
2,355 reads
Developing with SQL Server: Three ways to get at data
Getting at data within a .NET application can be straightforward using built in controls or much more complex through connections,...
2011-04-07
2,075 reads
SQL Validation Functions - 4 Cool UDF's to have handy
Everyone knows that in SQL 2000, yes 2000, Microsoft jumped aboard the bandwagon of other platforms, and gave the developers...
2011-04-07
12,319 reads
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with...
2011-04-06
3,375 reads
Change SQL Startup Parameters with PowerShell
Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...
2011-04-05
1,493 reads
The DBAs Guide to Expectation Management
Your customers expectations are their primary measure of your success. How well are you managing them?
You’re reading The DBAs Guide...
2011-04-04
2,065 reads
Maaaaaagic Tables!!!
I had an interview earlier this week. An interview for a SQL developer position. It went fine. But. Question number X...
2011-03-30
4,648 reads
The Mystery Of The Slow Last Row
Things Go South
Recently I was troubleshooting a piece of software that archives data out of a very active import table....
2011-03-29
2,259 reads
Statistics, row estimations and the ascending date column
SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they...
2011-03-28
1,643 reads
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
BCA Multifinance Cabang Kedoya Hub.0851•8812•0691
BCA Multifinance Cabang Kedoya Hub.0851•8812•0691 Citta Graha, Jl. Panjang, RT.5/RW.1, South Kedoya, Kebonjeruk, West...
BCA Finance Kelapa Gading Layanan Mobil Hub.0851•8812•0691
BCA Finance Kelapa Gading Layanan Mobil Hub.0851•8812•0691 Ruko Mall Of Indonesia Blok B 32-33,...
BCA Finance - Depok Hub.0851•8812•0691
BCA Finance - Depok Hub.0851•8812•0691 Komplek Perkantoran, Ruko Pesona View, Jl. Pesona Khayangan Jl....
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers