Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Database Rss

   Items 1 to 20 of 21    Older >>
 

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more.  Read more...
By Sean Smith 2016/01/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,085 reads

Database Backup Information Scripts

Scripts used to validate the backups information as below 1) Database Backups for all databases For Previous Week 2) Most Recent Database Backup for Each Database 3) Most Recent Database Backup for Each Database - Detailed 4) Databases Missing a Back-Up Within Past 24 Hours  Read more...
By Sathya Praveen 2015/11/25 | Source: SQLServerCentral.com | Category: database
Rating: |  Discuss |   Briefcase | 1,304 reads

Figure out recovery mode for each database

It is anoying that someone created a new database and left its recovery mode in simple and it caused your backup jobs to fail.  Read more...
By Michael Zhang 2015/11/23 | Source: SQLServerCentral.com | Category: database
Rating: |  Discuss |   Briefcase | 554 reads

Backup all SSAS databases using TSQL

Enumerates and backups all SSAS DB's  Read more...
By Theo Ekelmans 2015/05/13 | Source: SQLServerCentral.com | Category: automatic
Rating: |  Discuss |   Briefcase | 2,467 reads

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more.  Read more...
By Sean Smith 2016/01/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,085 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 2014/08/29 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,822 reads

Database Collation Is Null

By Andy Warren 2014/01/17 | Category: collation
Rating: (not yet rated) |  Discuss |   Briefcase | 1,840 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 2014/08/29 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,822 reads

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more.  Read more...
By Sean Smith 2016/01/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,085 reads

Move an On Premise SQL Server Database to the SQL Azure Cloud

I’ve introduced my manager to SQL Server’s cloud based platform, SQL Azure and Windows Azure Virtual Machine. He wants to test functionality with some of our applications, which would require me to move my on premise databases to the Azure Virtual Machine. What is the easiest way to accomplish this task? See how it is done in this tip.  Read more...
By Additional Articles 2013/08/15 | Source: Quest | Category: sql azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,729 reads

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more.  Read more...
By Sean Smith 2016/01/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,085 reads

Locate a column across databases

This utility will locate a column across a subset or all databases across a server. Can be configured to run across versions, and can search tables, views or both.  Read more...
Rating: |  Discuss |   Briefcase | 1,199 reads

Backup all SSAS databases using TSQL

Enumerates and backups all SSAS DB's  Read more...
By Theo Ekelmans 2015/05/13 | Source: SQLServerCentral.com | Category: automatic
Rating: |  Discuss |   Briefcase | 2,467 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 R Dedhia 2012/10/02 | Source: SQLServerCentral.com | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 1,379 reads

Rename column

By Pradeep Suvarna 2012/07/25 | Category: database
Rating: (not yet rated) |  Discuss |   Briefcase | 2,669 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 | 933 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 2014/08/29 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,822 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,340 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 | 565 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,733 reads
   Items 1 to 20 of 21    Older >>
 
Tags
administration (2)    
powershell (2)    
t-sql (2)    
all databases (1)    
analysis services (ssas) (1)    
automatic (1)    
backup (1)    
backup and restore (1)    
bi (1)    
collation (1)    
columns (1)    
creation (1)    
data warehouse (1)    
databasepropertyex (1)    
details (1)    
dimensional modeling (1)    
indexing (1)    
instance (1)    
kimball (1)    
monitoring (1)    
primary key (pk) (1)    
properties (1)    
recovery mode (1)    
search (1)    
server (1)    
serverproperty (1)    
settings (1)    
size (1)    
smo (1)    
sp_msforeachtable (1)    
sql azure (1)    
summary (1)    
sys.database_files (1)    
sys.dm_os_sys_info (1)    
table (1)    
tables (1)    
temporary tables (1)    
transaction log backup failed (1)    
trending (1)    
uptime (1)    
utility (1)    
view_column_usage (1)