Sending multiple rows to the Database from an Application: Part II
In part 2 of this series, Mohd Nizamuddin looks at sending multiple rows to the database from an application using XML.
Investigating Transactions Using Dynamic Management Objects
There can be a great difference in the performance of a particular routine in a test database, and in a fully loaded production system. When you hit performance problems in a database under load, and there is excessive locking and blocking, how can you determine exactly where the problems lie, in order to fix them?
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...
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers