Powerful, Flexible Text-Formatting Solutions in SQL Server
You can build very powerful and flexible text-formatting solutions in SQL Server. Learn how to apply techniques that handle the simplest to the more complex text-formatting tasks.
Hiring A DBA
How do you go about looking for someone to fill a DBA position? SQL Server guru and head of the Colorado Springs PASS Chapter, Chris Shaw, brings us a look at how an experienced manager goes about filling DBA positions.
SQL Server 2005 - Unattended installation - Part I
Automating the installation of SQL Server was made simple in SQL Server 2005. SQL Server 2005 can be installed using a GUI, an ini file or just run setup.exe with a bunch of parameters.
Executing SQL Stored Procedures from inside a Web Application
This article, the last in the Stored Procedure series, will focus on RETURN parameters.
An Interview with Bob Beauchemin
Over the last year we've taken a look at a number of people influential in the SQL Server community. This time Steve Jones spent a little time interviewing noted trainer and author Bob Beauchemin.
Security in the CLR World Inside SQL Server
s running .NET Framework code within SQL Server 2005 exciting or a threat? Which is it? This article explores the security issues of SQLCLR code so that both developers and DBAs can make informed decisions about its use.
Contract Work
Make a little extra money and find a contract job through our partnership with HohGigs.
Differential Backup Tricks
Differential backups are left out of many DBAs backup strategy, but they are a great tool to shrink your backup window, save disk space, and more. However they can be slightly tricky when you look to perform a restore. New author Qian Ye brings us an interesting issue that occured during differential testing.
Tuning Up SQL Server 2005 Databases
SQL Server 2005 comes with a built-in answer to this problem: the Database Engine Tuning Advisor. Combining a simple user interface with a deep knowledge of SQL Server, this utility can help you tune your databases for peak performance.
Database Commenting Guideline
Commenting seems to be the bane of every programmer, database or otherwise. Sachin Dedhiya brings us a look at brings some standards to how you should comment your code in a SQL Server database.
Blogs
Mastering the ORDER BY Clause in SQL Window Functions
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
How to Get Web Design Clients: 12 Practical Tactics That Work
By Rob Sewell
Getting clients is tough. Here's actionable advice to make building business easier.
SQL Data Pipelines: The Ultimate Guide to Streamlining Your Data Flow
Want to build a data analytics foundation that transforms raw data into valuable business...
Forums
New article
Comments posted to this topic are about the item New article
Monitoring Azure Blob Storage
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers