Script for all Foreign Keys of all tables of a DB
Foreign Keys of all tables in a database? with? table? name? and? column? name??
2008-01-08 (first published: 2006-12-27)
1,054 reads
Miscellaneous
Drop a Column and its Constraints and Indexes
Drops the specified column from the specified table as well as any constraints and indexes that depend on the column. By default the script will just find the corresponding column, constraints, and indexes.Comes in handy for patching databases.
2007-01-24 (first published: 2006-12-21)
2,458 reads
Date String format with optional Timestamp
I find it so annoying to format dates. Sometimes I want to include the timestamp, but if it is a midnight time stamp, the time is irrelevant. Sending in a datetime will return either the date string or a date string with a timestamp up to the seconds with either AM or PM.
2007-01-02 (first published: 2006-12-20)
202 reads
Function to find the current age
Use this script to figure out the current age of a person or object. It also takes leap year birthdates into consideration. You can also use this to find out the age of something at a particular point of time.
2007-01-04 (first published: 2006-12-19)
204 reads
Introduction to Bitmasking in SQL Server 2005
The use of bitmasking is usually limited to decoding values in the system views, but it can be useful in other places when you want to save space. New author Lee Everest brings us an introduction to bitmasking and its use in SQL Server 2005.
2007-12-05 (first published: 2006-12-13)
18,653 reads
Developers and DBAs
The battle between developers and DBAs can be a rough one at times. However DBAs are often outnumbered by developers and need to be sure they fit in. DBA Janet Wong brings us one of her experiences about how you can better go with the flow.
2007-11-29 (first published: 2006-12-05)
8,938 reads
Function Used to Reformat Phone Numbers
Can use this to select , insert and update phone fields into a standard format. Select FormatPhone(phone_column) from table Update Table set phone_column=FormatPhone(phone_column)Where ...Insert Into Table ( column1, phone_primary ...) Values ( 'qwerty', FormatPhone(1455846677)And the like --
2007-01-25 (first published: 2006-12-01)
455 reads
Create System Proc to Grab Row Counts for Tables
Really basic way to help identify tables that have 0 rows, etc. It uses the sp_MSForEachTable to crawl the database. Very simple script.
2007-01-10 (first published: 2006-12-01)
231 reads
Ten Ways To Lose Your DBA Job
We often see ways to improve your career, but there's a flip side as well. In the spirit of our "worst practices" series, Steve Jones takes a look at ten skills that could cost you your job if you can't perform them.
2007-12-03 (first published: 2006-11-30)
67,769 reads
Upsert Dimension Table
We get Vincent Rainardi's "Data Warehouse Loading Part 2" article taking a look at how you can perform an "upsert" in your data warehouse.
2006-11-28
14,511 reads
Blogs
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 ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
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