A New MCP Benefit
We would like to think that most DBAs are certified as at least MCPs if not MCDBAs. We have worked out a deal with Microsoft to provide yet another benefit for MCPs. Read on to find out more.
2005-02-15
6,147 reads
Press Release
Freeware: SQL Digger 1.0
Ever been in the situation where you know that you used a function in a stored procedure and couldn't remember how to use it? SQL Server is a great database platform, but it's easy to lose track of all your code as an application grows. A new freeware utility is available to help you search your databases for code.
2005-02-08
5,295 reads
Book Sale
SQLServerCentral.com is having a sale. Support the site and get some valuable information for your library.
2005-01-24
2,627 reads
SQLServerCentral.com Email Changes
The staff at SQLServerCentral.com really appreciates your support and contributions to the community. We are always looking to improve things here and we have made a couple changes to the way our email system works.
2005-01-11
2,977 reads
Northern Virginia SQL Server Users Group Reformed
The Northern Virginia SQL Server Users group serves the Maryland and Virginia areas around Washinton DC. The group is being restarted by Brian Moran and Jeremy Kadlec. If you're in the area, please read about this announcement and give them your support.
2005-01-10
2,518 reads
SQLServerCentral.com Celebrates our 200,000 Member Milestone
Many thanks from Andy, Brian, and Steve to everyone for their participation and efforts in building the best SQL Server site and the best community on the Internet. In appreciation of their efforts, we've given away a few gifts to some random members.
2005-01-10
2,478 reads
Webcast: Six Principles for Increasing the Speed of Business Intellige
Trey Johnson, a PASS board member and a senior business intelligence consultant, is doing a webcast on Tuesday. Join him for a great talk getting a business intelligence system up and successful in your environment.
2005-01-10
2,660 reads
Decorum in the Forums
One of the most valuable features of SQLServerCentral.com is the discussion forums, where many a DBA has found an answer to their question. Most times on the same day! While we do not moderate the forums, there are still some rules for posting that we hope everyone will take a moment to read.
2005-01-03
3,247 reads
TiVo for DBAs!!!
SQLServerCentral.com is all about learning. Our goal has been to build a community where we all teach each other how to become more proficient with SQL Server. Most of our content to date has been written articles that show you how to do something. Well we have a a better idea, maybe. Check out our new video HOWTO series.
2004-12-16
3,750 reads
Microsoft Wants to Hear From You
A short survey from Microsoft looking for feedback from users in order to try and improve the application development process. If you build applications with MS technolgies, especially SQL Server, take a moment and respond.
2004-12-10
2,820 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers