Are you using alerts to help you keep track of things? Are you using as many alerts as you should be? Jeremy has a great list of alerts that he considers so important they are on his 'best practice' list. Definitely worth reading.
2004-01-08
11,533 reads
Ramesh writes about various indexing strategies that you might use to improve performance.
2004-01-07
10,684 reads
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.
2004-01-06
6,418 reads
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.
2004-01-05
21,786 reads
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!
2004-01-02
22,783 reads
Hopefully you never hear any of these from your sysadmin...
2003-12-31
8,121 reads
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.
2003-12-30
4,265 reads
Joseph discusses some common and not so common security threats including the possibility of a TSQL virus and bombs planted from within the organization.
2003-12-29
5,828 reads
This article on CNET has some info about how Yukon affects the MS strategy in other areas.
2003-12-29
3,447 reads
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)
2003-12-26
3,369 reads
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
By Steve Jones
This image is from 2010, and it goes along with my last post of...
All week we've had issues with the site being up and down. There's been...
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers