End to End Training
The training arm of SQLServerCentral.com is spinning off to its own company. This is the place to come for high quality custom training.
2006-10-16
2,337 reads
Articles
Design Challenge: Global Address
Are you up to the latest design challenge? A great way to sharpen our analysis and modeling skills is to continuously address real-world scenarios. A modeling scenario with suggested solutions appears each month in this Design Challenge column. The scenario is emailed to more than 1,000 modelers. The responses are then consolidated into this column.
2006-10-16
2,039 reads
How to Schedule a SQL Server Database Creation Script
Scripting out your SQL Server 2000 objects is useful in any number of ways. You can save off the scripts for version control, generate the scripts needed to migrate to new hardware or a new environment, or just package up your application for deployment. Jon Reade brings us a look at the SCPTXFR utility, which can prove very valuable in managing your scripts.
2006-10-13 (first published: 2005-04-14)
38,841 reads
Executing all SSIS packages in a folder: three methods
This article examines a variety of ways in which you can execute all the SSIS packages in a folder.
2006-10-13
1,958 reads
Migrating From DTS to SSIS - Part 1
In this presentation, Brian talks about the good, the bad, and the ugly of DTS migrations. Then, he shows you how to migrate a simple DTS package to SSIS and some of the challenges you will see.
2006-10-13
2,839 reads
SQL Server Spotlight on Ian Jose
We've been profiling quite a few members of the SQL Server development team and this time we get a few minutes with Ian Jose, one of the query processing team.
2006-10-12
3,177 reads
Anticipate the worst when developing SQL Server databases
Arthur Fuller advises DBAs to try to break their software in order to make sure their SQL Server databases can withstand potential attacks. See if your code can hold up to his suggested tests.
2006-10-12
3,499 reads
Writing Simple Select Statements - Part 2
In this second part video from Kathi, she covers how to write T-SQL in much more indepth. She covers how to handle NULLs and many more items in this video.
2006-10-12
2,787 reads
Reporting Services 2005 101 using Web Client
Continuing with his series on different aspects of Reporting Services, Asif Sayed examines the next installment with a step by step tutorial demonstrating the power of locally processed Reporting Services with the ASP.NET Web Client.
2006-10-11
11,454 reads
Dealing with Database Concurrency Conflicts in the Real World
Database concurrency conflicts are somewhat of a plague in software development because they're hard to predict and handle. Unfortunately, they're also hard to prevent.
2006-10-11
2,638 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat kantor BCA KCP Galuh Mas Telp:0817866887
WhatsApp:0817-866-887 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers