<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
Database
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
Read more...
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)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
