(Marcin Policht) Despite its benefits, SQL Server Integration Services’ Import Export Wizard has a number of limitations, resulting in part from a new set of rules that eliminate implicit data type conversion mechanisms present in Data Transformation Services. This article discusses a method that ad

(Anu Chawla) Restoring a database is an essential part of any DBA’s job running Workforce Central. If you cannot restore a database, you will almost certainly lose your job. Thus, the topic of restoring a database seems well worth digging into more deeply.

(Pinalkumar Dave) It is interesting how sometimes the documentation of simple concepts is not available online. I had received email from one of the reader where he has asked how to create Primary key with a specific name when creating the table itself.

(Kay Unkroth) Microsoft SQL Server PowerPivot technology redefines how IT departments deliver and succeed with BI. This technology gives users the power to drill into any aspect of their business and compress decision cycles to gain deeper insight, and it enables them to share their findings with ot

(Tim Ford) I have a number of scripts I run against new SQL Server installs to, among other things, create my SQL Server Agent backup jobs. Typically, the jobs for my backup processes are all the same, across my environment with the exception of a few variables. One of those is the default backup

(AmruthaVarshiniJ) Recently I came across an issue wherein you are installing SQL Server 2005 on an n-node Windows cluster. The setup keeps on failing with the following error message on GUI screen:

(Tim Cullen) We are working on the migration to SQL Server 2008 and have geospatial data that we would like to move over as well. As part of our application we house information on locations across the globe. Which data type should we use?

(Kevin Kline) My poor workstation has to put up with some unusual requirements for flexibility. Much of the time, it’s a simple personal workstation on which I write documents, compile spreadsheets, and answer email. At other times, I need it to behave like a high-end database server, or, at least

(Robert Sheldon) In part one, you learned some basic T-SQL string functions and how to use them. This article takes things one step further with examples of how to get the most out of string functions by converting numerical and character data, gathering additional information and performing a SOUND

(Deanna Dicken) When a SQL Server object is created that references another SQL Server object, such as a stored procedure called from a trigger, that dependency is recorded by the database engine. This article details how to get at that dependency information.