This past week the Exchange 2010 team admitted they had tried SQL Server as a storage platform for Exchange 2010, but then discarded it. Steve Jones wonders why this was the case. Is SQL Server not good enough?
2009-07-20
516 reads
Find the country, region and city of a user from an IP address using SQL Server. Oscar Garcia provides some code and resources if you want to dig into your analytics on your own.
2012-07-20 (first published: 2009-07-09)
55,305 reads
Many DBAs need to work with multiple platforms. New author Jagan Kumar brings us an article that helps to explain Oracle's architecture for those people used to working with SQL Server.
2009-07-02
10,804 reads
Use of event handlers provided in SSIS package to handle runtime errors while the package is running and logging the error information in the database.
2009-06-26
13,756 reads
Face it, you never intended to become a SQL Server expert, but the proliferation of this database engine – and its many editions – requires somebody to feed and care for it. You're the "Microsoft Guy" (or Gal), so whether you wanted to be or not, you were elected. This series of articles is all about making you more effective with SQL Server as an administrator, not a programmer.
2009-06-25
7,556 reads
Learn about the benefits of SQL Server 2008 consolidation on Windows 2008, with details on the different consolidation strategies available to organizations.
2009-04-07
2,707 reads
I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fill out any missing data, please post in the comments and I'll update the article.
2009-02-04
3,287 reads
An interview with Herain Oberoi, group project manager for the SQL Server Business Intelligence and Data Warehouse product.
2009-01-02
2,872 reads
This refresher on SQL Server examines when to use a database as well when not to, along with some of the key terms used with SQL Server.
2008-09-09
3,025 reads
Backup all DBs of a SQL-Server Instance depending on Environment Variable "DBBackupPath". The script also distinguishes between Instances
2008-05-22 (first published: 2008-03-28)
2,413 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Comments posted to this topic are about the item Local Agents
Comments posted to this topic are about the item Detecting Deadlocks
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers