SQLServerCentral.com is proud to launch it's first Resource Center for security. It's a one-stop shop for anything related to SQL Server security. All content is user-contributed and contains links to content throughout the web.
2002-05-20
67 reads
It provides an infrastructure to create and manage various SQL Server stored procedure based reports into HTML output. You can add reports, categorize them in a treeview, edit, delete and manage the report parameters - all through the web interface. Members can now download this as Freeware at SQLServerCentral.com.
2002-05-16
113 reads
Is the Identity property part of a transaction? I always thought so, but decided to test it and see what happens.
2002-05-16
4,564 reads
2002-05-15
2,953 reads
This article shows you how to use the CASE function to design single query solutions that have changing results depending on the values you assign to variables. These techniques are extremely useful as alternatives to dynamic SQL.
2002-05-14
10,820 reads
Version control for stored procedures isn't always popular and certainly isn't easy. Or can it be? Andy discusses a technique he used on a recent project that you might find interesting.
2002-05-10
13,449 reads
SQLServerCentral.com has crossed 40,000 users! Thanks for all of you telling your friends about our site and making us a strong SQL Server community. To thank you, you can request to receive a free DTS object model poster that we worked on in conjuction with Lumigent. To sign up to get your hard copy, go to http://www.lumigent.com/go/sqlcentral05
2002-05-10
3,336 reads
2002-05-08
3,239 reads
Multi server administration allows you to create jobs and maintenance plans once. You can then monitor and change them from one SQL Server. View job histories and statuses for 2, 4, 10, or more SQL Servers from one master SQL Server. See how you can simplify your administration duties with multi server administration.
2002-05-06
13,105 reads
RAC's domain name has changed to rac4sql.net. Read their sad fight with their hosting provider here.
2002-05-06
51 reads
By Brian Kelley
Microsoft Fabric is the new data offering in Microsoft Azure and there is a...
By Rohit Garg
In the expansive landscape of software development, the relationship between Database Administrators (DBAs) and...
It was great being at dataMinds Saturday 2024 this past weekend. A great crowd...
I'm hoping someone here has encountered this before and was able to fix it....
Hi everyone, So I have a SSIS package that performs some importing/exporting from MySQL...
Hello SSC, I am not a DBA,. I have some DBA knowledge, but my...
In which editions of SQL Server 2022 can you run Reporting Services?
See possible answers