Fire Drills
How often do you have those fire drills, testing what you would do in the event of an emergency. Would you be satisfied with a 30% success rate?
2008-03-18
32 reads
Articles
Screencast: Tracking memory with PerfMon counters
Learn how to use SQL Server PerfMon counters to track Windows memory. SQL Server MVP Kevin Kline explains the maximum numbers to watch for when using PerfMon memory counters.
2008-03-18
2,894 reads
The curse and blessings of dynamic SQL
How you use dynamic SQL, when you should - and when you should not.
2008-03-18
6,537 reads
2008-03-17
7,697 reads
Understanding DDL Triggers in SQL Server 2005
SQL Server 2005 includes a number of new security enhancements to aid the DBA in managing their SQL Server. DDL triggers allow you to trap all kinds of DDL events that occur on your server. S. Srivathsani brings us a look at these new events.
2008-03-17 (first published: 2007-07-04)
15,796 reads
Get Rid of the Indexes
An idea that could save time and resources for backup and recovery in SQL Server.
2008-03-17
32 reads
Get Rid of the Indexes
An idea that could save time and resources for backup and recovery in SQL Server.
2008-03-17
29 reads
SQL Server 2005 Express Edition - Part 17 - Merge Web Synchronization
In this article, we will explore another variation of this mechanism, called Web Synchronization, with SQL Server 2005 Express Edition instances operating as merge replication subscribers connecting to a publisher via HTTPS protocol.
2008-03-17
998 reads
2008-03-16
34 reads
2008-03-16
37 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers