Indexing Strategies
Ramesh writes about various indexing strategies that you might use to improve performance.
Using Bits to Store Data
David recently worked on a project where it turned out storing the answers to a survey using bitmapping was a good approach. He was good enough to write some of it down and share. As he notes bitmapping isn't used as often as it used to be, but it can still be a useful technique to have around.
Using xp_cmdshell
Haidong continues to point out ideas that might get you thinking about ways you can do more administration with less work. In this article he demonstrates a couple useful tasks you can do with xp_cmdshell.
Introduction to MDX
New Author! This is an introductory level look at MDX geared toward intermediate or higher SQL users. The rate of OLAP usage is lower than it should be - maybe this will be what gets you started using it. Or thinking about it at least!
Top 100 things you don't want the sysadmin to say
Hopefully you never hear any of these from your sysadmin...
Building SQL Server Central
Ever wonder how SQL Server Central.com was built? Ever wonder why the three founders made the decisions they did? Here's a look at some of the choices that were made early on with the discussion forums.
TSQL Virus or Bomb?
Joseph discusses some common and not so common security threats including the possibility of a TSQL virus and bombs planted from within the organization.
Yukon News
This article on CNET has some info about how Yukon affects the MS strategy in other areas.
Review of MySQL/PHP Database Applications
We haven't had a book review in a while and this one may not be of interest to all of you, but we decided to take a chance and post it anyway! As Andy notes in the review, odds are that you'll deal with one or both of these applications sooner or later, might be worth thinking about taking a look at what they can do. (Reviewed)
Automatically Gathering Server Information Part 2
The second part of Steve Jones's series on having SQL Server automatically report information to a DBA.
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 KCP Bitung 082225313145 WA CS
WhatsApp 082225313145 Jl. Sam Ratulangi No.86, Bitung Tim., Kec. Maesa, Kota Bitung, Sulawesi Utara...
Alamat BCA KCP Tomohon 082225313145 WA CS
WhatsApp 082225313145 Jl. Kolongan Jl. Raya Tomohon No.10 d/a, Kolongan, Kec. Tomohon Tengah, Kota...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers