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.
2010-10-22 (first published: 2009-08-25)
18,623 reads
Articles
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?
2010-10-22
3,228 reads
Notifications for SQL Server Agent Restarts
This article demostrates how to set up email notifications for SQL Server Agent Restarts.
2010-10-21
1,926 reads
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...
2010-10-21
2,806 reads
Mid October Free Training from PASS Virtual Chapters
More free training this month from PASS B/I, PowerShell, and Oracle Virtual Chapters.
2010-10-20
720 reads
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.
2010-10-20
8,297 reads
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.
2010-10-20
1,918 reads
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...
2010-10-20
4,525 reads
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
2010-10-19
4,427 reads
Detective Stories - Changing the Case
How to change your "UPPER" or "lower" case strings to a mixed case
2010-10-18
6,100 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Ketapang Telpon/WA:08137887595
BCA KCP Ketapang Telpon/WA:08137887595.Blok A/3-4, Ketapang Indah, Jl. KH Zainal Arifin, Krukut, Kec. Taman...
BCA KCP Financial Center,Telpon/Wa 0821-8200-239
Ruko Financial Center, Jl. Gading Serpong Boulevard No.1 Blok BA 2, Pakulonan Barat, Kec....
BCA Finance WTC Mangga Dua Telpon/WA:0851•8812•0691
BCA Finance WTC Mangga Dua Telpon/WA:0851•8812•0691 Gedung WTC Jl. Mangga Dua Raya. 8 Lantai...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers