DTS is a great tool in SQL Server 2000 for easily setting up jobs to import or export data. But it can also have security risks. New author Alex Kersha brings us a simple security technique to be sure that you are properly executing your DTS packages in a secure manner.
2005-12-20
5,964 reads
By default, SSIS files in development are encypted to prevent an unauthorized person from seeing your SSIS package. The type of encyrption is seamless behind the scene and is at a workstation and user level. So, if you were to send a package that you're developing to another developer on your team, he would not be able to open it by default. This shows you how to fix this problem.
2005-12-20
1,683 reads
Robert is our expert on dynamic sql. This week he offers some good hints for planning the contruction of a proc that will use dynamic sql. He also adds some suggestions on how to format the code so that when you return to it later, you can figure out what you were doing!
2005-12-16 (first published: 2003-04-25)
51,469 reads
Despite a growing range of options for integrating mixed database environments, some companies are sidestepping the problem by moving to a single database platform.
2005-12-16
2,322 reads
Apress is giving away some copies of this book on SQLServerCentral.com by sponsoring our Question of the Day. A sample chapter is also available online now!
2005-12-15
4,660 reads
Continuing with his series, Andy Warren looks at what it means for SQL Server 2000 command line parameters as well as checkpointing with this service.
2005-12-15
9,850 reads
In this lesson, we revisit Named Sets, a subject that we undertook in my article MDX in Analysis Services: Named Sets in MDX: An Introduction, in March of 2004. There, we introduced Named Sets from the perspective of the MDX query language, having obtained brief exposure to the concept of Named Sets earlier in the MDX in Analysis Services series (Using Sets in MDX Queries). We examined Named Sets as they existed within Analysis Services 2000, touching upon them from the perspective of Analysis Manager, the Cube Editor, and related interfaces in Analysis Services.
2005-12-15
2,193 reads
Steve Jones recently took the 70-441 Beta exam for Developing Solutions on SQL Server 2005. This article will not break the NDA and tell you what the content is, but it gives you some feedback from a SQL Server 2000 DBA on the new exam.
2005-12-14
12,894 reads
With the introduction of SQL Server 2005, Microsoft has created a new .NET management API for SQL Server called SQL Management Objects (SMO). As I started working with SQL Server in earnest following its release I discovered a few limitations that I hoped to correct using SMO. This article describes those problems and how to use SMO to script database objects.
2005-12-14
2,552 reads
A quick and dirty procedure to allow you to grant execute permissions to a user, or role, quickly and easily.
2005-12-13
9,980 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Telp/Wa 628218200203 Gedung Metro, Jl. Samanhudi No.103 Lt. Dasar No. 101, 102, Ps. Baru,...
Telp/Wa 628218200233 Jl. Balikpapan No.21 A-B, RT.9/RW.6, Petojo Sel., Kecamatan Gambir, Kota Jakarta Pusat,...
Telp/Wa 628217555651 Pasar Regional Tanah Abang, Kios No.F-081 Blk A Basement I/G-063, F-080, Kp....
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers