One of the best benefits of the .NET Framework over lower level programming is that it enables developers to create very complex, custom solutions, without writing low-level code. Zach Smith explores how you could take advantage of the built-in .NET Framework functionality to develop a simple object oriented database in less than 140 lines of code.
2007-01-19
4,211 reads
Every DBA should know what is going on with their database servers, but this is a chore that requires some type of tool to help. SQLCentric from Pearl Knowledge Solutions is a tool that can help you and SQL Server MVP Satya Shyam brings us a look how to setup and use this tool in your environment.
2007-01-18
4,488 reads
2007-01-18
2,208 reads
In this presentation, Ira shows you how to data profile in SSIS using a Script transform and some creative methods like RegEx. He shows you how to look for patterns in your data to find bad data that wouldn't be obvious to the eye or casual viewer.
2007-01-18
1,543 reads
In this article author Paul Mu shows us how you can create a custom component for the new SQL Server 2005 Integration Services environment.
2007-01-17
17,601 reads
Part 40 of this series reviews a Web Service Control Flow task that exposes an infinite range of easily deployable features by leveraging capabilities present in the .NET Framework.
2007-01-17
2,598 reads
This article describes how to implement a single refactoring within your database. It contains a worked example of the Move Column structural refactoring, whereby we move the Customer.Balance column to the Account table, a seemingly straightforward change to improve the database design.
2007-01-16
3,244 reads
Learn how to keep track of previous versions of code in case your next upgrade doesn't go well from SQL Server guru Tim Chapman.
2007-01-15
2,928 reads
Learn how to calculate days of the week based on the current date and how to calculate accounting months.
2007-01-12
3,468 reads
In this presentation, Brian Knight shows you how to use canned SSIS components to detect data changes in a source table and only load new or conditionally update changed records. He shows you two methods: one using the OLE DB command and another using a set based operation and demostrates you the performance differences between the two.
2007-01-12
2,108 reads
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Quite the title, so let me set the stage first. You have an Azure...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
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