By now everyone should have heard about the PASS 2004 Summit in Orlando this September. Hopefully you are also aware that SQLServerCentral.com is one of the sponsors for this event and to make it a bit special, we're putting on a reception for everyone that registers for PASS with our promotion code. Read on to see what we've got planned!
Need to proper case names? Want a quick way to reformat a series of words? This article examines a SQL approach to quickly proper casing all words in a field.
If you're into fantasy football, come waste some time with us and join our free league at Yahoo. Read the below instructions on how to join. Space is limitted in the first league to 12 teams so join quickly and the draft starts Tuesday! If it's popular, we'll create other leagues.
In order to join the league, just go to http://football.fantasysports.yahoo.com/f1,
click the "Sign Up Now" or "Get Another Team" button and
follow the links to "Join a Custom League". When prompted,
enter the League ID# and password below.
League ID#: 525071
Password: ssc
Notification Services is one of the features included in SQL Server 2005. As the name implies, Notification Services are services which send notifications to the interested entities based on what they would like be notified on. In this article you will see how to implement Notification Services in SQL Server 2005
A new article from MSDN magazine on stopping SQL Injection attacks by examining how the SQL can be exploited. It's a good basic article for developers as well as DBAs who might have to review code.
An article from Microsoft Journal looking at the new Mining features of SQL Server 2005. If you're interested in Analysis Services, this ias a good look (from a high level) at the next version.
The final installment in Darren Fuller's series on change management in SQL Server. If you haven't read the others, be sure to go through them before reading this one to learn how automating your version control in SQL Server is needed for any development shop.
SQL Server can grow to encompass hundreds of databases on a single server, each having hundreds or thousands of objects within it. A truly scalable RDBMS. However, how many times have you been searching through the Object Browser in QA or the left pane in Enterprise Manager searching for an object? New Author Ashish Kaushal gives us a method to easily search your server for that long lost object.
Analyzing the data storage in SQL Server databases is a bit of an art. It's a skill that takes some time to develop given that the tools are rather limited. DBCC SHOWCONTIG is one of the few ways in which you can get some insight into how SQL Server has structured your table on the disk. Joe Sack brings us another of his top xxx techniques with his ten queries that you can use to analyze the results of this command.
SQL Server has great client side tools, Query Analyzer, Enterprise Manager, for working with your server and managing it. But how many times have you wished for a web interface because you didn't have VPN or didn't want to give rights to a developer. Or maybe you host clients' databases on your server and don't want one person to see another's databases. Read this review by someone who actually uses this product.
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
I’ve been running this blog on Hugo for a long time, and like most...
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Comments posted to this topic are about the item RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers