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
6 Can’t-Miss Basic SQL Courses to Learn in 2024: Your Fast Track to Data Mastery
Ready to dive into the world of SQL? Whether you're dreaming of a lucrative...
Data-driven vs. Data-informed: Let’s Acknowledge the Truth
This comic was retweeted into my timeline on Twitter (I refuse to call it...
Writing Parquet Files – #SQLNewBlogger
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...
Forums
Monitoring if something is deleted in DB
Hello, I have long-term task, which came one year ago, and just now I...
LOGON Trigger Count
Comments posted to this topic are about the item LOGON Trigger Count
Invisible Downtime
Comments posted to this topic are about the item Invisible Downtime
Question of the Day
LOGON Trigger Count
I have the need in SQL Server 2022 to create a complex set of checks for logins. I want to use Longon triggers, but I'd like to separate out logic. How many Logon Triggers can I create?
See possible answers