Sybase linked server in sql 2005
How to create and configure Sybase linked server in SQL Server 2005
2009-07-21 (first published: 2009-07-09)
688 reads
Scripts
Find SQL Server Authentication Mode Configuration
Quick Method to find Configured???????????????????????? Authentication Mode
2009-07-20 (first published: 2009-07-07)
935 reads
2009-07-17 (first published: 2009-07-08)
931 reads
Prime Number Table Generator (new ver crunches to 1 Mil in <10.5 sec!)
Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded.
2009-07-15 (first published: 2009-07-03)
1,349 reads
Three Sample reports for the Automated DBA: Space Usage SnapShotter
1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot
2009-07-13 (first published: 2009-07-03)
2,500 reads
Get DDL for any SQL 2005 table
returns CREATE TABLE script for any table. including schema name,calculated columns,
indexes with INCLUDE,rules,defaults,triggers,constraints,extended properties...everything.
2009-07-11
1,921 reads
2009-07-08 (first published: 2009-06-25)
1,188 reads
Drive space checking monitoring procedure
This procedure can used to monitor the disk drive space details and we can set threshold and it can be enhanced to send an alert incase of reaching the threshold.
2009-07-07 (first published: 2009-06-23)
2,213 reads
2009-07-06 (first published: 2009-06-23)
4,974 reads
Export/import relational data across SQL Servers
The XportXML utility, will help you copy relational data (a bunch of related tables) to another SQL Server keeping the relational integrity intact, even when new primary keys are generated.
2009-07-03 (first published: 2009-06-22)
1,590 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Alamat BCA KCP Tendean Telp:0821-8200-203
Telp/Wa 62 8218200203 Jl. Wolter Monginsidi No.129, RT.2/RW.2, Rw. Bar., Kec. Kby. Baru, Kota...
Alamat Kantor BCA KCP Tendean Telp:0817.82.5533
Telp/Wa 62 817825533 Jl. Wolter Monginsidi No.129, RT.2/RW.2, Rw. Bar., Kec. Kby. Baru, Kota...
Alamat BCA KCP Gandaria City Telp:0821-8200-233
Telp/Wa 62 8218200233 Gedung Mal Gandaria City Mainstreet-Upper Ground M-U25, Jl. Sultan Iskandar Muda,...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers