SQL Azure with ASP Dot Net
Don Schlichting demonstrates the development of a SQL Azure ASP Dot Net application, leveraging our existing TSQL and Dot Net skills.
2009-12-11
6,129 reads
Additional Articles
Profiling SSIS packages for component level change tracking
In this tip we will look at an add-in that helps you better identify changes between two versions of an SSIS package.
2009-12-10
3,071 reads
Query Active Directory Data from SQL Server using T-SQL
Learn how to use SQL Server Transact SQL with OPENROWSET and OPENQUERY commands to access and retrieve data from Active Directory.
2009-12-09
5,402 reads
Best Practice for renaming a SQL Server Database
One of the Junior SQL Server Database Administrator in my company approached me yesterday with a dilemma. He was assigned a task to rename few of the databases in Beta and Production environments; the reason being the database name was based on some other project that is no longer relevant to the data which is presently stored within the database. At first I started to tell him, but figured it would be smarter to document the same and share the information.
2009-12-08
6,195 reads
Databases in the Cloud: Elysian Fields or Briar Patch?
The cornucopia of products for handling distributed data in the cloud includes everything from lightweight key-value stores to industrial-strength databases
2009-12-07
2,186 reads
Understanding SQL Server fixed server roles
I know there are fixed server roles that come with SQL Server. How do I best use them within my installations? What should I watch out for?
2009-12-04
5,135 reads
Explore filtered models in SQL Server 2008
This articles explores how you can work with filtered models, a powerful new feature introduced in SQL Server 2008 that allows you build models on slices of a mining structure.
2009-12-03
2,607 reads
SQL Server Encryption Symmetric vs. Asymmetric Keys
I need to encrypt my data within SQL Server and I plan on using the built-in encryption functionality in SQL Server 2005 and 2008. However, I'm looking at symmetric and asymmetric key algorithms and while I see information saying to use symmetric keys, I don't understand why. What's the difference between the two and why is a symmetric key algorithm preferred over the asymmetric key ones?
2009-12-02
3,414 reads
Keeping Track of Virtual Databases
Are your database servers not performing well? Have you discovered two or more virtual servers running on the same node? Shailesh Khanal shows you how to generate a status report for multiple database servers and services, schedule it to run automatically and send it out via email.
2009-12-01
2,555 reads
SQL Server Integration Services (SSIS) - Troubleshooting Best Practices
In the previous tips (SQL Server Integration Services (SSIS) - Best Practices - Part 1 and Part 2) of this series I briefly talked about SSIS and a few of the best practices to consider when designing SSIS packages. Continuing on the same rhythm I am going to discuss some more best practices for SSIS package design, how you can design high performing packages with parallelism, troubleshooting performance problems etc.
2009-11-30
3,785 reads
Blogs
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Forums
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
UNISTR Basics
Comments posted to this topic are about the item UNISTR Basics
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers