Cheap Fun
Today we have a guest editorial from Andy Warren that talks about ways to enjoy life without spending a lot of money. Some of these might even be great team building ideas.
Notifications for SQL Server Agent Restarts
This article demostrates how to set up email notifications for SQL Server Agent Restarts.
When was SQL Server Restarted?
While doing some performance testing recently and utilizing some of the DMV’s I figured, I better find out when the...
Mid October Free Training from PASS Virtual Chapters
More free training this month from PASS B/I, PowerShell, and Oracle Virtual Chapters.
Plan for Capacity
It is important that you are monitoring your system to handle the capacity increases as it grows. Steve Jones notes that FourSquare recently had to deal with this.
Writing Nearly Codeless Apps: Part 3
As we continue in this series, see how auditing tables are used to track all changes that are made to the main data tables.
Add Some Spark to Your OData: Creating and Consuming Data Services with Visual Studio and Excel 2010
The Open Data Protocol (OData) is an open REST-ful protocol for exposing and consuming data on the web. Also known as Astoria, ADO.NET Data Services, now officially called WCF Data Services in the .NET Framework. There are also SDKs available for other platforms like JavaScript and PHP.
Powershell is Really Easy… If you know what you’re doing
Sigh… I just spent almost a full work day trying to come up with, what turned out to be a...
Living Moore's Law
eBay has quite a new data center in Utah, replacing all their hardware on a two year cycle. Steve Jones thinks that would be a challenge, and an exciting one at that.
Robyn Page's SQL Server String Manipulation Workbench
String searching and manipulation in SQL Server can be error-prone and tedious...unless you're armed with the techniques described in Robyn's string manipulation workbench, here newly revised with extra material from collaborator Phil Factor
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor BCA KCU CIREBON Telp.0817839777
WhatsApp-0817839777 Jl. Yos Sudarso No.27, Lemahwungkuk, Kec. Lemahwungkuk, Kota Cirebon, Jawa Barat 45111
Alamat BCA KCU SOEKARNO HATTA Telp.0817839777
WhatsApp-0817839777 Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung, Jawa Barat 40227
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I specify only the Resource Database?
See possible answers