A Cynic's Top Ten Tips for IT Contractors
As autumn approaches, Patrick Index produces his ten hot chestnuts for IT Contractors like himself, with a jaundiced 'contractor's-eye view'.
2007-09-26
5,583 reads
Miscellaneous
The Socialization of Knowledge
This article is an excerpt from the forthcoming book, Business Metadata, to be published on or about September, 2007, co-authored by Bill Inmon, Bonnie O’Neil and Lowell Fryman, published by Morgan Kaufman.
2007-09-25
2,175 reads
Strategies for Testing Data Warehouse Applications
This article presents a strategy for testing ETL applications that perform data movement and populate data warehouses. It is useful information for the testing community as well as designers and managers charged with planning a data warehousing implementation.
2007-09-21
2,460 reads
Find Parent Child RelationShip
Many times with work with unknown databases, most of the time there is not a clear documentation of the relations between tables, however, with this script we are able to find the parent child relations in just a few seconds
2007-09-18
995 reads
Script to find text in stored procedures
This is a simple script that when used by command-line OSQL/ISQL can help you locate a stored procedure.How many times have you been looking for stored procedure code and could not find it? This is a simple method to locate lost code.When you manage many database servers this can become a common problem. The scenario […]
2007-09-14
2,081 reads
Combine multiple rows into single output
We can use this function to combine multiple rows into single one. Generally to create comma separated list for each unique item. So this can create comma separated product list for any given category. The same can be used to make a list of items in a given order.ThanksMohit Nayyarhttp://mohitnayyar.blogspot.com/
2007-09-14
3,817 reads
LSTR() and RSTR(): Enhanced LEFT() and RIGHT()
Quite often I need to cut off the first (or last) few characters of a string. To do just that I created two functions LSTR() and RSTR().Syntax: LSTR( @stringtocut, @length )Note: @stringtocut is trimmed in the functionWhen @length is equal or larger than zero, this function performs the same as LEFT( LTRIM(RTRIM(@stringtocut)), @length ).When @length […]
2007-09-13
1,584 reads
Making the Most of Operational Analytics with Enterprise Decision Mana
EDM solutions are a logical and often necessary complement to operational analytics.
2007-09-11
1,296 reads
What Specification Server Should I Buy?
Simon Sabin is always cagey about giving advice on the sort of hardware to run SQL Server on, but admits to some general rules.
2007-09-10
4,327 reads
finding the blocks in sql server
Hai buddies,The following procedure can be used to find whether there are any blocks in the sql server.The procedure if run in Master database , can be used like any other system stored procedure from any database.The output of the proc will contain the followingSPID OF RUNNING APPLICATIONAPPLICATION NAMEEXECUTING DATABLOCKED (Y/N)BLOCKING SPIDBLOCKING APPLICATIONEXECUTING DATA (BLOCKING […]
2007-09-09
3,703 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers