|
|
|
|
 |
| Articles |
by Microsoft MVP Andrew Couch |
| SQL Server Tips and Tricks Part 1 |
 |
When a problem suddenly surfaces you usually need a fast answer to solve it. In his new series of quick tips and tricks, Anil will show
us how to solve commonly occurring problems with SQL Server. |
|
| UK MSDN Flash eBook Best Technical Articles #1 |
 |
Eric Nelson, Technical Editor at UK MSDN has very kindly allowed me to add this fabulous PDF to SQL Server Club! The UK MSDN Flash developer newsletter contains great short technical articles written by UK developers both inside Microsoft and in the broader developer community. This eBook pulls these great articles together in one place. This first edition contains 13 articles covering dynamic languages, testing, game development, cloud computing and more.
Download your copy now! |
|
| Articles |
by Microsoft MVP Andrew Couch |
| Articles |
by Shafqat Tanzeel |
| How to Document SQL Server Using BI Documenter from Pragmatic Works |
 |
Anil Mahadev takes a look at Pragmatic Works' BI Documenter tool to see how it handles documenting SQL Server. Using AdventureWorks he leads you step by step using the trial edition.
Documentation at the click on a button? Surely this is Anil's easiest assignment yet! |
|
| Articles |
by Rick Obsitnik |
| Control Who Connects to SQL Server and Who Does Not |
 |
This handy code from Rick will help you in your cross-server work. Use these scripts to end all user connections based on an instance, a database, a particular login or a login start and/or end time frame. |
|
| Articles |
by Rick Obsitnik |
| How to Compare the Columns of Two SQL Server Tables |
 |
Being able to compare two tables is a common requirement in SQL Server environments, especially where development and
production servers exist. Rick explores a functional way to do this task in an enterprise environment using linked servers. The SSMS file for this article is also included. |
|
| Articles |
by Rick Obsitnik |
| Minimarts: Organizational Segmentation in Datawarehousing |
 |
If you don't know much about datawarehousing, then who better to learn from than a real life expert? Rick Obsitnik works with datawarehouses in his day to day role as a SQL Server DBA, so
this introduction on how you can utilize datawarehousing to make your job indespensible is essential reading. Get to know how datawarehousing, datamarts and minimarts
can fit in to your organization and your job! |
|
| How to Recover from a Corrupted Database in SQL Server 2000 |
 |
This is one useful article that you'll want to keep to hand! Anil takes you through the steps needed to bring a SQL Server 2000 databse back online.
It's easy to panic when crisis strikes, so save the PDF version of this document and keep it so you can find it when you really need it! |
|
| How to Deal with Negative SPIDs in SQL Server |
 |
If you've ever run sp_who or sp_who2 and encountered a SPID with a negative number, that is SPID = -2, then you may have found yourself in a position where you couldn't kill it off the conventional way. Take a look at this article to find out how to kill it off. |
|
| 21 Hot Tips for Improving Your SQL Server Security |
 |
Make your SQL Server as water tight as you can with this concise list of hot tips to tighten those leaks! These tips cover the areas of physical security,
account security, DBA and developer tips, SQL Server configuration and permissions. Included are tips to keep data safe when it needs to be taken off site,
and how to make sure you don't give users more access than is necessary. |
|
| Linked Server Queries Stop Working After Applying Windows Server 2003 SP2 |
 |
If you upgrade to Windows Server 2003 Service Pack 2 on a linked SQL Server, it can stop the Distributed Transaction Controller (DTC) from working. Why is this? Well, it's Microsoft's way of
tightening up security, but it can leave you with a connection that no longer works. Follow this easy article and re-establish your connection in just a matter of minutes. |
|
| SQL Server Service Packs - When Should You Apply One? |
 |
Knowing when to apply a service pack to SQL Server isn't as straight forward as you might first think. Do you apply it as soon as Microsoft
releases it, or wait a while and see what problems arise? What if you don't apply it? We put these questions and more to our expert DBA and asked, "Just when is the
best time to apply a new service pack?" |
|
| SQL Server Service Packs: Applying them to Development and Production Servers |
 |
Applying a service pack to SQL Server in production and development environments can have different impacts
because the set-up of each environment is somewhat different. What's the best way to go about this and can you apply the same
principles to both systems? Use this article to plan how you're going to roll out your service pack upgrades. |
|
| Going Virtual, Going Green |
 |
Virtual machines are gaining ground in both reliability and cost-effectiveness in a production environment. As VMs become a
normal part of every day server room installs, they are helping in a seemingly invisible way to help reduce climate change.
Possibly not the first advantage that may have come to mind when you installed yours... |
|
| Job Details Vanish in SQL Server Management Studio |
 |
Strange things can happen in the world of development and even stranger things seem to happen when SQL Server service packs are involved.
In this case it's a matter of disappearing job properties in Management Studio before the service pack had even been applied. If weird
things are occurring inside your client tools, then read this article. |
|
| How to Set Up Database Mail on SQL Server 2005 |
 |
Database mail is a great way of getting SQL Server to tell you when it's done something. Or, when it's not done something and a job has
failed. You can use it to keep you informed of actions by sending an email to you, whether you're at your desk or on the road with your laptop
or mobile, as long as you have an internet connection, you can get SQL Server to keep you updated. |
|
| Ten Things a DBA Should Never Do |
 |
So you're the top dog for data in your company. The DBA. Responsible, stable and reliable. That's you. But are you doing anything which could
jeopardize your company's data or even your career? This light-hearted look at the things a DBA should never do covers some serious points and
is essential for existing DBAs and anyone thinking of a career change... |
|
| How to Schedule a SQL Server Database Creation Script |
 |
SQL Server Management Studio makes it easy to right click and generate a script to create databases. That's all well and good but what happens
when you need to schedule such a task? Did you even know it was possible? This article looks at how you can use a little utility called SCPTXFR.EXE
to schedule the creation of databases. |
|
|
|
|
|
|
|