Enough is Enough
When do you decide that enough is enough? When does it make sense to let some bugs go and fix them later? Steve Jones comments on the decisions you sometimes make.
2008-07-06
57 reads
Articles
Enough is Enough
When do you decide that enough is enough? When does it make sense to let some bugs go and fix them later? Steve Jones comments on the decisions you sometimes make.
2008-07-06
57 reads
How to Export Data to Microsoft Office Excel 2007 Using SQL Server 2005
This article provides a step by step guide on how to export data to Microsoft Office Excel 2007
2008-07-04
8,937 reads
Managed Data Access Inside SQL Server with ADO.NET and SQLCLR
Using the new SQLCLR feature, managed code can use ADO.NET when running inside SQL Server 2005. Learn about SQLCLR via basic scenarios of in-process data access, SQLCLR constructs, and their interactions.
2008-07-04
2,591 reads
An MVP From Way Down South
Please join us in congratulating one of our longtime community members on MVP status.
2008-07-03
754 reads
2008-07-03
10,710 reads
Happy 4th of July
A blooper collection of mistakes and errors from a variety of editorials on this holiday weekend.
2008-07-03
587 reads
Happy 4th of July
A blooper collection of mistakes and errors from a variety of editorials on this holiday weekend.
2008-07-03
602 reads
Missing Date Ranges- the Sequel
Alex Kozak returns with another Date puzzle. A question from a Simple-Talk reader gives Alex the inspiration to see if is possible to list unused date ranges in one Select statement.
2008-07-03
3,048 reads
The Database Weekly Update for July 7, 2008
Intel is moving in the direction of more and more cores on a single CPU, so what does that mean for programmers?
2008-07-03
233 reads
Blogs
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...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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