Featured Article(s) Attach all databases in a single sp execution The following procedure called usp_AttachAllDBFromINI takes a database name and mdf files list that resides in an INI file. The procedure loops over the file and attaches all databases listed in it to the server. Do You Have Your SQL Server Operators and Notification Set Up… Yet? I am repeatedly […]
Author: Ben Taylor
Maintenance Plans Gotchas SQL Server 2005
Featured Article(s) Maintenance Plans Gotchas SQL Server 2005 It almost looks as if SQL Server 2005 Maintenance Plans have been tossed into a blender with SQL Server 2000 DTS. In my opinion, for what its worth, I like the new look. But what should you watch out for… Final Thoughts on "Trust, But Verify" Jon writes "For SQL it should […]
Small Shop DBAs and Due Diligence for Your SQL Server
Featured Article(s) Introducing the F# Programming Language The F# programming language an object oriented and functional multi paradigm programming language (combines the best of the best features of other languages) based upon OCaml, is freely available from Microsoft. It is a functional programming language that can be executed on top of Microsoft .NETs managed platform and provides a lot of […]
Due Diligence in a Smaller IT Shop, Particularly with Databases
Featured Article(s) Tips for using SQL Server 2005 Database Console Commands (Part 2) In this article, Alexander Chigrik shows how you can optimize SQL Server 2005 performance by using database console commands. Due Diligence in a Smaller IT Shop Some great feedback on the "Trust, But Verify" discussion from yesterday. Please send in your thoughts here. Stephen: "This is an […]
Protecting Your Systems… from DBAs?
Protecting Your Systems… from DBAs? Karen wrote in with a link to this story about a DBA that was caught stealing, then dismissed, of course. On the way out, they decided to take down the database for the company, effectively putting the company out of business. Lovely. There are a number of things that come from this story. First, the […]
Lessons Learned, Providing Reports to Users
2009 at SSWUG.ORG 2009 will be a killer year here at SSWUG – we have a series of new, exciting things that are coming to the site that will continue to make sure you can find what you need (and make it much easier to do so), contribute and even find local SSWUG affiliated user groups. We’ll be rolling things […]
Granting Access vs. Creating Reports In Your SQL Server System
Granting Access vs. Creating Reports Randy writes in with some feedback and thoughts about the question of whether it’s best to give your end-users full access to your databases so they can build their own reports, or is it better to build custom reports as needed, so you don’t have to give access… "It depends on the setup of your […]
ROI of Creating Meaningful Views for Users?
Happy Holidays! As we head into the holidays – we just wanted to say thanks for a great year – from the Virtual Conferences to programs, content and community, we sincerely have enjoyed working with you this year. A lot of people don’t realize the SSWUG, the vConferences and other things we’re doing are not just a couple of people […]
What If Information Came with a Chain of Evidence?
New SelectViews Show LINQ to SQL Server, Multi-Server Management, System Stored Procedures – What is Referencing Them? The 60-Second Tip of the Day, the Accidental DBA Tip, Locking & Blocking, More… [Watch The Show Here] A Little Down Time This Week? …but still need to be there at work? Check out a SSWUG.ORG webcast while you can – just head […]
A Developers Guide to Data Modeling for SQL Server (Book Review)
Featured Article(s) A Developers Guide to Data Modeling for SQL Server (Book Review) Books are starting to get a little repetitive. There are the ones that you can count on for the core of your knowledge; there are ones that you use for reference, but what happens when you need a book that teaches you something that may be foreign […]