The Database Weekly Update for June 16, 2008
Steve Jones looks back at the news of the past, including a look at RC0, the latest release of SQL Server 2008.
The Database Weekly Update for June 16, 2008
Steve Jones looks back at the news of the past, including a look at RC0, the latest release of SQL Server 2008.
Eliminating Cursors
T-SQL does some things wonderfully, but cursors are the bane of the language, often causing performance issues. Changing your queries around to remove cursors can be tricky and new author Kamran Ali brings us one technique he has used to dramatically improve performance.
Include Column Headers From SSMS
Save time when copying data from SSMS to Excel by configuring the options to Include Column Headers.
Compound Assignment Operators in SQL Server 2008
MAK illustrates the use of Compound Assignment Operator that is introduced in SQL Server 2008.
Introduction to the Unified Dimensional Model (UDM)
This paper provides an introduction to the Unified Dimensional Model (UDM), including the basic end-user model, and a brief overview of the architecture and security models.
What do you do with a new SQL Server?
This article highlights some basic steps to take when you have a new install of SQL Server or take over support of existing databases.
Close these Loopholes - Reproduce Database Errors
This is the final part of Alex's ground-breaking series on unit-testing Transact-SQL code. Here, he shows how you can test the way that your application handles database-related errors such as constraint-violations or deadlocks. With a properly-constructed test-harness you can ensure that the end-user need never see the apparent gobbledegook of database system error messages, and that they are properly and robustly handled by the application.
Security Overview for Database Administrators
SQL Server 2008 is secure by design, default, and deployment. Microsoft is committed to communicating information about threats, countermeasures, and security enhancements as necessary to keep your data as secure as possible. This paper covers some of the most important security features in SQL Server 2008. It tells you how, as an administrator, you can install SQL Server securely and keep it that way, even as applications and users make use of the data stored within.
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Alamat BCA KCU DIPONEGORO 082225313145??WA CS
WhatsApp 082225313145 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
Alamat BCA KCU VETERAN 082225313145 WA CS
WhatsApp 082225313145 Jl. Veteran No.18-24, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa Timur 60175
Alamat BCA KCU GALAXY 082225313145 WA CS
WhatsApp 082225313145 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers