Data Mining in Excel 2007 Pt.2 - SQL School Video
In this video MVP Brian Knight continues on with more advanced data mining using Excel.
Global Warming and Business Intelligence
What does global warming have to do with BI? Steve Jones explains.
Challenging the Tyranny of Third-Party Vendors: A DBA’s Manifesto
Over the years, I have dealt with a lot of third-party applications (and their vendors) that use SQL Server as their back-end databases. It has often been an uneasy relationship, fraught with pain and tribulation. The overriding feeling I have gotten...
Conservative or Risky?
What type of leadership do you want in your company? Steve Jones asks who you want to help steward you through these tough economic times.
Conservative or Risky?
What type of leadership do you want in your company? Steve Jones asks who you want to help steward you through these tough economic times.
Conservative or Risky?
What type of leadership do you want in your company? Steve Jones asks who you want to help steward you through these tough economic times.
Introduction to Change Data Capture in SQL Server 2008
This article takes a look at the great new auditing features available in SQL Server 2008.
SSIS 101: Isolating Data in a Data Flow
MVP and SSIS expert Andy Leonard brings us a new article on how to work with a data flow and manipulate your data in complex ways.
The New Office
A tour of the new Red Gate Software offices from Steve Jones, looking at how a modern software company has set up it's space.
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