Securing Your SQL Server posted 11/15/99 Poorly managed SQL Server Security can not only leave your SQL Server vulnerable, but also leave your NT Server and network open to attacks. A DBA must find a balance between securing the server and leaving an environment that will be productive for developers. This article takes a moderate approach to locking down your SQL Server. [Check it out...]
SID Finder posted 11/12/99 Here's a script that will get a listing of all SIDs on a machine and the username with which it corresponds. [Check it out...]
Updates to the SMS Home Page... posted 11/11/99 SMS Scripts/Utilities/Queries
- Windows 2000 RC2 Query
- IPCFG Script - updated
Script : List Stored Replication Commands posted 11/11/99 The usp_UtilReplicationBrowseCommands stored procedure
will list the replication commands stored in the
distribution database with the option to specify the
published server, database, and article [Check it out...]
Using System_User posted 11/10/99 Imagine knowing who modified the data in a table. The system_user function will allow you to do just that. The system_user function will report who is currently logged into your SQL Server database. Find out how in this quick TSQL tip. [Check it out...]
Script : Replication Schema posted 11/9/99 The usp_UtilReplicationSchema stored procedure will
list the published servers, databases, publications,
articles, subscribed servers and databases per user
query conditions.
[Check it out...]
Script : How Old Are Your Databases? posted 11/9/99 Find the age of your database by day. SP_AGEOFDATABASE will tell you, in days, when each of your databases were created.
For SQL 7.0 [Check it out...]
Hot Thread : Restoring at the Table Level posted 11/8/99 In SQL Server 7.0, is is it possible to restore a single table from a database backup?
[Check it out...]
Service Pack Season posted 11/8/99 A new Microsoft strategy for the releasing of service packs is to now release them on a timed basis. The result of this is you will see many more service packs, keeping the their suite of products a little more bug free. Find out more information about these service packs here. [Check it out...]
Script to Load a Time Dimension posted 11/8/99 Loads a time dimension for a Data mart, Data warehouse, etc. The only variables to change are the increment (an integer for days or weeks or months), the Start date and the End date. The script will loop through and load the table. [Check it out...]
Getting Network Drives - SMS posted 11/6/99 Here's an example script that uses the CRLF variable to create a drop-down list with just one variable. This script searches all drive letters and returns a list of the network drives. [Check it out...]
Using an Underscore in Variable names posted 11/4/99 The documentation for both WISE & SMS Installer state that variable names can contain letters, numbers, & underscores ("_"), and variable names can start with either letters or underscores. However, incorrect results are achieved in some instances... [Check it out...]
Using a Tab in a Variable posted 11/4/99 Although not really a variable, one can make a Tab stop into a variable in either WISE or SMS Installer. This can be helpful if one wants to display information on the screen and they're using a non-proportional font. [Check it out...]
GVCustomTask - using package global variables posted 11/3/99 This DTS custom task allow you to use package global variables in Execute SQL Tasks. [Check it out...]
Set SQL Server User Permissions in a Snap! posted 11/3/99 This freeware program allows you to easily Grant Select, Insert, Update, Delete, and DRI permission on all USER tables and views as well as Execute permission on all USER stored procedures in a database. [Check it out...]
Updated: DSO Cube Processor (ActiveX DLL) posted 11/2/99 Now supports Dimension processing with two new methods, ProcessDimension and ProcessAllDimensions. Example scripts updated. [Check it out...]
Using a Carriage Return Line Feed in a Variable posted 11/2/99 An undocumented variable in WISE is the CRLF variable, which inserts a carriage return line feed when used. With SMS Installer, one can create this variable by pasting specific code into the Script Editor... [Check it out...]
SQL Server 2000 Beta Watch posted 11/2/99 As you may have heard, at the recent PASS conference, it came out that SQL Server 8 ("Shiloh") would likely be called SQL Server 2000 in line with Exchange 2000 and of course Windows 2000. Shiloh is now in the hands of some select early testing accounts - approximately 200 or so. These accounts are the first to get their hands on the software - more comprehensive beta testing starts early in 2000 [Check it out...]
OLAP - Food For Thought...Your History In The Making? posted 11/1/99 I would humbly suggest that if you're not all over OLAP. Reading, studying, learning, using and doing work with OLAP quietly in the background while others are only talking about it, you're not only missing out, but possibly jeopardizing your position. [Check it out...]
XP_ENUM Extended Stored Procedures posted 10/29/99 Digging a little deeper this week into extended stored procedures, we find the xp_enum procedures. These procedures require no parameters but provide a handy bridge to the operating system and is extremely helpful for developers. [Check it out...]
OLAP Services in 5 Minutes posted 10/27/99 So what is OLAP Services? OLAP Services is now used widely to analyze warehoused data in an easy to understand drill-down GUI. You can think of a cube as a department in your organization. You could create a cube for your marketing department to see how sales have increased with marketing over the past year. We will build your first cube in this article, starting you with your OLAP solution. [Check it out...]
Properly Encoding SQL Statements posted 10/22/99 One of the biggest questions that people come to me regarding SQL statements is when the data that they need to store in the database contains a single quote (my dog's name is scoobie). [Check it out...]
Question and Answer : XP_GETFILEDETAILS and File Size posted 10/22/99 In reference to your article "XP_GETFILEDETAILS - File Detail Via TSQL" on SWYNK, can you please elaborate on the example a bit and show how to use this to get the size into a variable, for example? In other words, I need to do something if the size of file is greater than a given size. How would I do this in T-SQL? [Check it out...]
SMS Home - Updates posted 10/21/99 SMS Articles
- Adding a New Chipset to the Accelerated Video Drivers List
SMS Reference
- Creating Custom Admin Consoles
SMS Scripts/Utilities/Queries
- Internet Explorer Version Query for SMS 2.0
- OSTYPE Script: OS Revision Type
- CHIPSET Script: Retrieving Manufacturer Video Information
The SMS 2.0 Post SP1 BugList has been updated.
- The Palm Pilot versions are now also Windows CE compliant. See the site
for more information.
Registry Extended Stored Procedures posted 10/21/99 Examples of how to read, write and delete registry values using SQL Server extended stored procedures. These xp's are not documented in SQL Server Books Online and therefore unsupported by Microsoft. [Check it out...]
Populating a dropdown box from a database... posted 10/21/99 then use JavaScript to take action based on the OnChange event. Find out how, here! [Check it out...]
Advanced SP_MSFOREACHTABLE posted 10/21/99 Make this already useful stored procedure even better. SP_MSFOREACHTABLE will scan through every table in a given database and perform an action. Essentially this stored procedure gives you the ability to do one line cursors. Learn how to filter which tables you'd like to scan and more advanced options this week. [Check it out...]
Using the COMMAND object to insert rows into the database posted 10/20/99 Find out how! EXPOSED: the command object for insertions... [Check it out...]
Workaround of disabling SMS client installation by creating files with identical to SMS directories... posted 10/20/99 You can be faced to a problem, when a number of expirienced users preventing SMS client installation by creating files with identical to SMS directories names. Run this tool from the script, and you'll never get this problem again. [Check it out...]
New SP for 7.0 sp_wastedspace posted 10/20/99 SP_WASTEDSPACE will scan you tables for every column, finding out how much you're using of each column and report how much of that space allocated you're wasting. [Check it out...]
Using a ASP and a PLAIN text file as a simple HITCOUNTER! posted 10/19/99 This is the first of two demonstrations of how to create hit counters for your site. The biggest hurdle that we have to get over for both of these demonstration is how we keep track of each hit that the page receives. [Check it out...]
Installing SMS 2.0 in Clustered Environment posted 10/19/99 Microsoft says that installation SMS 2.0 in clustered environment is not supported, but after researching this problem, we understood that there are no strong restrictions to do so. Get the rest of the story here... [Check it out...]
Evaluating Spaceguard for NT in a cluster environment posted 10/19/99 While using Spaceguard in normal, non-clustered environment we were very curious about how this product will perform in a cluster-environment. [Check it out...]
ABCs of Warehousing posted 10/18/99 Learn the basics of data warehousing. The foundation of OLAP Services is built on warehousing and the accessability of your data. [Check it out...]
OracleZone.com - opens to provide sys admin and dev support for Oracle(tm) posted 10/18/99 OracleZone.com has opened - providing news headlines on Oracle and more. You can even contribute your favorite article, tip, script and more. Could be interesting... [Check it out...]
Write for SWYNK.COM and make Ca$h! posted 8/2/99 We pay you for your contributions! Become famous, get so well-known that you require a body-guard! Meet all the movie stars you've always wanted to know! Or, you can write for us! <g> Seriously, we work with you to build a solid following, and to help put some added cash in your pocket. Check out the unique details online today!
[Check it out...]
Post Your Jobs!
Do you need to fill your positions with qualified candidates? We have the answer - tell more than 60,000 people - twice - in the newsletter, and let 1000's of system administrators see your open positions here on SWYNK.COM! [Tell me more]
Advertising Info
