Over-Engineering
Steve Jones thinks that we often over-engineer software, trying too hard to consider every possibility rather than getting it close.
Over-Engineering
Steve Jones thinks that we often over-engineer software, trying too hard to consider every possibility rather than getting it close.
Testing with Profiler Custom Events and Database Snapshots
We've all had them. One of those stored procedures that is huge and contains complex business logic which may or may not be executed. These procedures make it an absolute nightmare when it comes to debugging problems because they're so complex and have so many logic offshoots that it's very easy to get lost when you're trying to determine the path that the procedure code took when it ran. Fortunately Profiler lets you define custom events that you can raise in your code and capture in a trace so you get a better window into the sub events occurring in your code.
Corporate Hackers
A report says that most of the data lost in corporations is from employees. What can be done about it? Steve Jones thinks we still have work to do in this area.
Database Mail, Part 2 - SQL School Video
Database Mail is an essential part of administering SQL Server for most people. MVP Andy Warren brings us part 2 of how to set up this subsystem.
Failing SQL 2005 Cluster Installation because of too many cpu's
A Failing cluster installation because of too many processors. Sander Stad explains how you might be able to solve this in your environment.
Corporate Hackers
A report says that most of the data lost in corporations is from employees. What can be done about it? Steve Jones thinks we still have work to do in this area.
Corporate Hackers
A report says that most of the data lost in corporations is from employees. What can be done about it? Steve Jones thinks we still have work to do in this area.
Corporate Hackers
A report says that most of the data lost in corporations is from employees. What can be done about it? Steve Jones thinks we still have work to do in this area.
Object Grouping Best Practices: Using Schemas for Logical Separation
You've probably all noticed a change since SQL Server 2000 with respect to objects: formerly DB.ObjectOwner.Object ,
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCU THAMRIN. Tlp:085373737845
BCA KCU THAMRIN. Tlp:085373737845.Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng,...
BCA KCP Grogol Permai Tlpn/wa:085373737551
Pert.Grogol Permai, Jl. Prof. Dr. Latumeten No.4 Blok F 3, Jelambar, Kec. Grogol petamburan,...
BCA KCU WISMA ASIA Tlpn/wa:085373737551
Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, Kota Bambu Sel., Kec. Palmerah, Kota...
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