SQLServerCentral Article

Nightmare Contest

Murphy's law has struck us all, as evidenced by the disaster entries we've received in the past. Imceda software, makers of Litespeed are sponsoring a new contest, looking for your nightmares.

SQLServerCentral Article

Review: NGSSquirrel

NGS Software is in the security business and have been very successful in finding vulnerabilities in many products, notable SQL Server. They have used their expertise to build products to help you better secure your systems. Dale Corey looks at one of those products, NGSSquirrel, which does vulnerability assessment.

SQLServerCentral Article

Database Change Management: An Automated Approach

SQL Server change management is tough. The tools don't integrate with version control systems, there isn't good administrative controls to enforce control, and often you need to buy a third party tool to make this work. New Author Darren Fuller takes a look at the various ways in which you can implement version control in SQL Server. This is part one of a four part series on version control in SQL Server.

SQLServerCentral Article

Lookup Table Design

Designing a SQL Server database is a challenging task. Making decisions about how to build tables, their relations, etc. can be a full time job for any DBA helping to build an application. Lookup tables are a part of just about every application that you work with or build a back end for. Leo Peysakhovich brings us an article on database design that deals specifically with lookup tables.

SQLServerCentral Article

Review: SQLCentric

Monitoring your SQL Servers is something every DBA must do. Checking job status, disk space, etc. is a frequent question seen in our forums. Pearl Knowledge Solutions has developed a product to help you easily setup monitoring on your servers from a web interface. SQLCentric gets 4 stars from author Bruce Szabo; read his detailed review on this fine product.

SQLServerCentral Article

The Bowling Challenge

Know anything about bowling? Or writing hard core TSQL? Or test driven development? Even if you don't, this might be a good way to build those skills. Write a stored procedure that can score a bowling game and you might win one of our books and a shirt!

SQLServerCentral Article

Comparison of Oracle Drivers

Oracle is usually a dirty word in the SQL Server community, but like it or not, lots of data resides in Oracle databases. And SQL Server is often used to gather this data together in a warehouse of some sort for spinning cubes, generating reports, etc. Haidong Ji looks at the various methods that you can connect to an Oracle driver and compares the speed of each. If you need to get data from Oracle, or may need to, this is the place you want to start.

Blogs

What is ALM in Fabric?

By

As someone who’s worked with data for over 20 years and with many cloud...

The Most Successful Startups in 2025 — And What They Have in Common

By

2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...

Blog a Day – Day 1: History of AI

By

it has been a year since i have not written much on the blog...

Read the latest Blogs

Forums

A Quick Restore

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Quick Restore

Guarding Against SQL Injection at the Database Layer (SQL Server)

By tedo

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

By JSB_89

I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...

Visit the forum

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 REPLACE
What happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance.

See possible answers