Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Database Rss

   Items 1 to 8 of 8   
 

Backup all SSAS databases using TSQL

Enumerates and backups all SSAS DB's  Read more...
By Theo Ekelmans 2013/03/28 | Source: SQLServerCentral.com | Category: automatic
Rating: |  Discuss |   Briefcase | 635 reads

Find Primary Column of all tables in database

This code helps in finding Primary Keys for all tables in a database.  Read more...
By Nitesh Dedhia 2012/10/02 | Source: SQLServerCentral.com | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 1,249 reads

Rename column

By Pradeep Suvarna 2012/07/25 | Category: database
Rating: (not yet rated) |  Discuss |   Briefcase | 2,570 reads

Create Normalised Databases with Powershell

Database creation with powershell SMO objects  Read more...
By Patrick Viennot 2012/07/06 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 849 reads

Database size trending with powershell

a script to import all database sizes from a list of servers into a table using powershell for trending purposes YOU MUST DOWNLOAD CODEPLEX SQL SERVER MODULE FOR THIS TO WORK.  Read more...
By Gene Hunter 2012/06/13 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,234 reads

Total Database Information At Your Fingertips Part - II

This article will help to get some basic information from your databases that may help you in different situations.  Read more...
By Rahul Kumar Ghosh 2011/11/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,270 reads

sp_MSforeachtable:Add SQL objects to multiple database on a server.

ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.  Read more...
By Mehernosh 2011/11/14 | Source: SQLServerCentral.com | Category: sp_msforeachtable
Rating: |  Discuss |   Briefcase | 485 reads

Using The Kimball Dimensional Modeling Tool

Using the Kimball Data Warehouse Modeling Tool in an agile setting supporting regular builds and integrated testing with work a rounds to cover non-SQL Server systems.  Read more...
By Jim Nichols 2011/10/31 | Source: SQLServerCentral.com | Category: bi
Rating: |  Discuss |   Briefcase | 6,215 reads
   Items 1 to 8 of 8   
 
Tags
powershell (2)    
t-sql (2)    
administration (1)    
all databases (1)    
automatic (1)    
backup (1)    
bi (1)    
creation (1)    
data warehouse (1)    
dimensional modeling (1)    
kimball (1)    
primary key (pk) (1)    
serverproperty (1)    
size (1)    
smo (1)    
sp_msforeachtable (1)    
ssas (1)    
sys.database_files (1)    
sys.dm_os_sys_info (1)    
table (1)    
tables (1)    
temporary tables (1)    
trending (1)    
view_column_usage (1)