SQLServerCentral.com - The Missing Manual
Lots of changes to the site, see how to work with some of them.
SQLServerCentral.com - V3
The third evolution in the history of SQLServerCentral.com is now out and available. Read all about the changes we've gone through.
Three Months
That's what we were estimating the rewrite of this site would take. After all, to me it's a pretty simple site, a few content sections, some date specific stuff, scheduling, a few admin tools, not that much, right?
DDL Triggers in SQL Server 2005
DDL Triggers are key improvement in SQL Server auditing, allowing tracking of events such as the creation of a new table, database or user.
10 Steps to Securing your SQL Server
Securing your SQL Server can be an arduous task, but very rewarding. This article covers 10 steps to properly protecting your data.
A Bit About 64-bit
64-bit SQL Server is coming!! Are you ready for this new technology? Chances are most of you are like us in that you've never had a 64-bit machine around and you likely don't remember the transition from 16-bit to 32-bit. Do you even want to make the transition? Is it worth it? New author Robert Pearl brings us a first look at how the 64-bit version of SQL Server will differ from the 32-bit version.
Access to SQL Server: The Upsizing Wizard
SQL Server 2000 is the basis for the new Access database storage. However there are still many cases where applications developed on Access are outgrown and need to be moved to SQL Server to support the load. Author Kathi Kellenberger brings us a look at the Upsizing Wizard and how you can move your databases to SQL Server.
Common Table Expressions in SQL Server 2005
The next evoution of T-SQL, which will be released in SQL Server 2005, contains a number of enhancements designed to allow you to write more powerful queries while keeping the code structured in a way that makes development and understanding it easier. Coming ever so closer to the SQL-99 specification with Common Table Expressions, new author Srinivas Sampath brings us an introduction to this new way of writing complex queries.
Database Standards and Conventions
Having a good set of naming conventions for your SQL Server objects is one of the most vital things to a company. In the long duration of a business, it saves money and time as programmers are transferred internally and don't need to relearn object names. As learning curves lower, cost lowers. This article covers some of the conventions that Brian Knight uses and why he uses them.
Encrypting Data With the Encrypt Function
One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer.
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers