2002 Reader's Choice Award Voting Begins
The SQLServerCentral.com Reader's Choice Awards voting has begun. Vote for the product or book that you feel is best in breed and saves you the most time. Voting is simple and takes less than a minute.
Certification Tips
This article by Andy Warren offers some suggestions to help you get ready for your first Microsoft exam.
Challenge the Community
Have a SQL Server question? Challenge the largest SQL Server online community in our forums! If you think your a guru, test yourself by helping a newer DBA. SQLServerCentral.com has active forums with over 100 posts daily.
Become an Author!
Want to be an author and be admired by the SQL Server community? Find out more details about how to be a writer for SQLServerCentral.com, visit this page.
The Microsoft SQL Server™ Accelerator for BI Launched
The Microsoft SQL Server™ Accelerator for Business Intelligence (SQL Server Accelerator for BI) makes it easy to build a customizable business intelligence solution from your operational data, enabling your organization to realize the power of business analytics.
Review of COMCompare by Red Gate
Andy takes a look at the third product in the popular bundle from Red Gate that does comparisons of COM components. Looks like it's easy to use and a nice tool to have around!
Creating your own sp_MSforeach stored procedure
This article shows you one of the most time saving stored procedure built into SQL Server and then shows you how you can modify it to affect additional objects like triggers. For example, after this article and the code in the article, you'll be able to disable every trigger in your system in one line of code.
Yukon Resource Center Launhced
This week, SQLServerCentral.com launched its Resource Center all about getting a sneak peak on Yukon. All links are user contributed.
SQLServerCentral.com Launches SQL Server Security Analzyer
SQLServerCentral.com launched its first online free software, which can evaluate your SQL Server remotely and look for SQL Server security vulnerabilities. This free service looks for weak or no passwords and does a basic penetration test online.
Updated Freeware Product SQLExecMS Released
Oleg Dantchenko has updated his very successful freeware product, SQLExecMS to release 1.5. The new release has a new look, more features and is perfect for rapid development and quick DBA work.
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
What is the best index strategy for a table that gets truncated?
Hi everyone My SSIS package does a bulk insert of csv files into a...
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers