Working with null values in SQL XML
We all know NULL values must be dealt with carefully in T-SQL, but how exactly do you best deal with them in SQL XML?
Top 10 Mistakes When Building and Maintaining a Database
Building and maintain a SQL Server database environment takes a lot of work. There are many things to consider when you are designing, supporting and troubleshooting your environment. This article identifies a top ten list of mistakes, or things that sometimes are overlooked when supporting a database environment.
Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods
This is the first of a series of articles to analyze the use of surrogate keys in different scenarios.
End of October Free Training from PASS Virtual Chapters
This wraps up the last of the free training the PASS Virtual Chapters are providing in October.
Remote Security
As more and more people look to work away from inside traditional networks, security becomes an issue. As a data professional, Steve Jones reminds you to be sure that your data is protected.
SQL Slammer
It's been seven years since SQL Slammer, the worst SQL Server security worm struck. Steve Jones remembers that time.
SQLServerCentral Webinar Series #3: Optimize your SQL Server storage with SQL Storage Compress
Another webinar from SQLServerCentral that examines how you can compress your data on any edition of SQL Server.
Introducing ADO.NET Entity Framework
The challenge of bringing data from efficient storage engines such as SQL Server into object-oriented programming models is hardly a new one. Most developers address this challenge by writing complex data access code to move data between their applications and the database. This requires an understanding of the database so that you can access data either from the raw tables, from views, or from stored procedures.
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?
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