SQL Server Password Management:
Improving SQL Server password management includes thorough password testing and securing SQL Server installations beyond the main database server.
2007-07-31
2,653 reads
Additional Articles
AJAX Stock Symbol Drop-down List
A web look up of a huge list of stock symbols from an MS SQL database.
2007-07-30
2,817 reads
10 tips for sorting, grouping, and summarizing SQL data
Arranging SQL data that you can effectively analyse requires an understanding of how to use certain SQL clauses and operators. These tips will help you figure out how to build statements that will give you the results you want.
2007-07-27
5,433 reads
A Discount on SQL Populator
Software Development Innovations is offering SQLServerCentral.com members a 20% discount on their products with a coupon of "sqlservercentral" used in their cart.
2007-07-27
2,309 reads
CLR: 9 Reusable Parallel Data Structures and Algorithms
This column is less about the mechanics of a common language runtime (CLR) feature and more about how to efficiently use what you’ve got at your disposal.
2007-07-27
2,632 reads
Keep a check on your IDENTITY columns in SQL Server
Be sure you don't end up with arithmatic errors in your identity columns from a SQL Server MVP.
2007-07-26
2,984 reads
A T-SQL Regular Expression Library for SQL Server 2005
This article shows the reader how to construct a library of scalar and table valued functions for SQL Server 2005 to perform regular expression analysis.
2007-07-25
4,024 reads
ADO.NET Entity Framework Overview
ADO.NET in the next release of Visual Studio® code-named "Orcas" features the new Entity Framework.
2007-07-25
2,551 reads
Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4
Part 3 of this series discussed how to script PowerShell and connect to SQL Server. This installment illustrates how to use a PowerShell script to loop through the content of a file and connect to different servers.
2007-07-24
2,479 reads
SQL Server 2005 Express Edition - Part 2
Express Edition remains the primary choice for deployments of a full-fledged database engine in less demanding environments. Part two of this series explores its features in more detail in order to better understand its unique role in SQL Server 2005 portfolio.
2007-07-24
2,562 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers