sqldbashare.blogspot.com

Lets Share Our SQL Knowledge

Lets Share Our SQL Knowledge. I would like to share my knowledge with those who wants to Learn SQL. Monday, February 10, 2014. Powershell script to rename all files in a directory. Path = "c: testdirectory". Filenames = get-childitem -name -filter *.mp4. Foreach ($filename in $filenames). Newfilename = "test video " $increment ".mp4". Write-host $newfilename, "Rename-item " $path$filename. Increment = $increment 1. Wednesday, November 13, 2013. Attach a database in the sql server. Is auto update stats on...

http://sqldbashare.blogspot.com/

OVERVIEW OF sqldbashare.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

17

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR SQLDBASHARE.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

June

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Friday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.4 out of 5 with 8 reviews

5 star

1

4 star

5

3 star

0

2 star

0

1 star

2

Hey there! Start your review of sqldbashare.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.2 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT SQLDBASHARE.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

17

SSL

EXTERNAL LINKS

0

SITE IP

74.125.225.10

LOAD TIME

0.188 sec

SCORE

6.2

PAGE TITLE

Lets Share Our SQL Knowledge | sqldbashare.blogspot.com Reviews

<META> DESCRIPTION

Lets Share Our SQL Knowledge. I would like to share my knowledge with those who wants to Learn SQL. Monday, February 10, 2014. Powershell script to rename all files in a directory. Path = c: testdirectory. Filenames = get-childitem -name -filter *.mp4. Foreach ($filename in $filenames). Newfilename = test video $increment .mp4. Write-host $newfilename, Rename-item $path$filename. Increment = $increment 1. Wednesday, November 13, 2013. Attach a database in the sql server. Is auto update stats on...

<META> KEYWORDS

1 pages

2 videos

3 articles

4 about me

5 scripts

6 cd c testdirectory

7 increment = 1

8 rename item $path$filename $newfilename

9 posted by

10 kumar katakam

CONTENT

Page content here

KEYWORDS ON PAGE

pages,videos,articles,about me,scripts,cd c testdirectory,increment = 1,rename item $path$filename $newfilename,posted by,kumar katakam,no comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,loading library files,clear host

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Lets Share Our SQL Knowledge | sqldbashare.blogspot.com Reviews

https://sqldbashare.blogspot.com

Lets Share Our SQL Knowledge. I would like to share my knowledge with those who wants to Learn SQL. Monday, February 10, 2014. Powershell script to rename all files in a directory. Path = "c: testdirectory". Filenames = get-childitem -name -filter *.mp4. Foreach ($filename in $filenames). Newfilename = "test video " $increment ".mp4". Write-host $newfilename, "Rename-item " $path$filename. Increment = $increment 1. Wednesday, November 13, 2013. Attach a database in the sql server. Is auto update stats on...

INTERNAL PAGES

sqldbashare.blogspot.com

1

Lets Share Our SQL Knowledge: February 2014

http://sqldbashare.blogspot.com/2014_02_01_archive.html

Lets Share Our SQL Knowledge. I would like to share my knowledge with those who wants to Learn SQL. Monday, February 10, 2014. Powershell script to rename all files in a directory. Path = "c: testdirectory". Filenames = get-childitem -name -filter *.mp4. Foreach ($filename in $filenames). Newfilename = "test video " $increment ".mp4". Write-host $newfilename, "Rename-item " $path$filename. Increment = $increment 1. Subscribe to: Posts (Atom). View my complete profile. There was an error in this gadget.

2

Lets Share Our SQL Knowledge: January 2013

http://sqldbashare.blogspot.com/2013_01_01_archive.html

Lets Share Our SQL Knowledge. I would like to share my knowledge with those who wants to Learn SQL. Thursday, January 10, 2013. Restore a Database using Windows Powershell. Load Assembly files for Sql server. System.Reflection.Assembly]: LoadWithPartialName("Microsoft.SqlServer.SMO") Out-Null. Initiate server object to connect the local server. Server = New-Object ("Microsoft.SqlServer.Management.Smo.Server") "(local)". DBRestore = new-object("Microsoft.SqlServer.Management.Smo.Restore").

3

Lets Share Our SQL Knowledge: Articles

http://sqldbashare.blogspot.com/p/articles.html

Lets Share Our SQL Knowledge. I would like to share my knowledge with those who wants to Learn SQL. Subscribe to: Posts (Atom). I have around 9 years of experience as MSSQL server DBA. Has knowledge on VB6.0, Crystal reports, Mysql, Sybase and oracle. View my complete profile. Powershell script to rename all files in a directo. There was an error in this gadget. Simple template. Powered by Blogger.

4

Lets Share Our SQL Knowledge: Scripts

http://sqldbashare.blogspot.com/p/scripts.html

Lets Share Our SQL Knowledge. I would like to share my knowledge with those who wants to Learn SQL. Find Unwanted Tables in the SQL server instance. I determine a table to be unwanted when the statistics were not updated or modified from the created time. Please verify with the application team why those tables were created and get the proper updates before deleting these tables. Exec sp msforeachdb @command1='USE? Dbname = db name() ,. OBJECTNAME = OBJECT NAME(I.OBJECT ID). SOBJECT ID IS NULL'. There wa...

5

Lets Share Our SQL Knowledge: Videos

http://sqldbashare.blogspot.com/p/videos.html

Lets Share Our SQL Knowledge. I would like to share my knowledge with those who wants to Learn SQL. Subscribe to: Posts (Atom). I have around 9 years of experience as MSSQL server DBA. Has knowledge on VB6.0, Crystal reports, Mysql, Sybase and oracle. View my complete profile. Powershell script to rename all files in a directo. There was an error in this gadget. Simple template. Powered by Blogger.

UPGRADE TO PREMIUM TO VIEW 12 MORE

TOTAL PAGES IN THIS WEBSITE

17

OTHER SITES

sqldbaonline.com

Abi Chapagai's SQLDBA Journal | DBA Journal

Abi Chapagai's SQLDBA Journal. What I Learnt Today! Posted on January 8, 2012. There are different types of replication in SQL Server 2008. They are listed below: 1. Snapshot Replication 2. Merge Replication 3. Transactional Replication 4. Merge Replication. Posted in Performance Tuning. SQL Server Blog…. Posted on June 18, 2011. This is a site where i will be posting Database stuffs. Posted in Performance Tuning. Posted on June 18, 2011. Posted in Performance Tuning. What I Learnt Today!

sqldbaonline.net

Media Conseil, spécialiste des technologies microsoft, formation et audit

Spécialiste des technologies microsoft, formation et audit. Cette offre est faite pour les petites entreprises qui n’ont pas de DBA permanent et qui ont un ou plusieurs serveurs de production Microsoft SQL Server toutes versions confondues (Version 7, 2000, 2005 et 2008). Les tâches suivantes sont comprises dans le forfait mensuel et s’effectuent une fois par semaine (le client peut choisir le jour de l’intervention s’il le souhaite) :. Contrôle de la cohérence des données. Toutes les questions support t...

sqldbaonlinetraining.com

SQL SERVER DBA Online Training. SHAREPOINT SERVER Online Training. SQL SERVER ANALYSIS SERVICES(SSAS) Online Training. SQL SERVER INTEGRATION SERVICES(SSIS) Online Training. SQL SERVER REPORTING SERVICES(SSRS) Online Training. Windows Server Clustering Online Training. Performance Tunning Online Training.

sqldbaonlinetraining.net

oracle functional technical workday online training

More Website Templates @ TemplateMonster.com - September08, 2014! Welcome To Magnific Online Training. Oracle Corporation's application portfolio consisted as. The Oracle E-Business Suite provides a set of financial applications used internationally in businesses. Workday is a web-based ERP software vendor that specializes in human capital management and financial management applications. We have well experienced and real time faculty working at MNC Companies. Magnific Online Training is Leading provider...

sqldbaschool.com

SQL DBA School with Abubeker A Refaw

SQL Server Administration and Management Tools. Different Editions of SQL Server. SQL Server Licensing Models. SQL Server Management Studio (SSMS). SQL Server Profiler continued. SQL Server System and Database Administration. Installing SQL Server 2008. SQL Server Installation Walkthrough-1. SQL Server installation walk-through-2. Upgrading SQL Server SQL Server. Upgrading SQL Server SQL Server-2. The SQL Server 2008 Upgrade Matrix. Client Installation and Configuration. Useful SQL DBA Perfmon Counters.

sqldbashare.blogspot.com

Lets Share Our SQL Knowledge

Lets Share Our SQL Knowledge. I would like to share my knowledge with those who wants to Learn SQL. Monday, February 10, 2014. Powershell script to rename all files in a directory. Path = "c: testdirectory". Filenames = get-childitem -name -filter *.mp4. Foreach ($filename in $filenames). Newfilename = "test video " $increment ".mp4". Write-host $newfilename, "Rename-item " $path$filename. Increment = $increment 1. Wednesday, November 13, 2013. Attach a database in the sql server. Is auto update stats on...

sqldbaskills.blogspot.com

SQL SERVER

Saturday, April 25, 2015. We can delete datafiles with the following commands. Current data will move to other available datafiles. DBCC SHRINKFILE (datafile4, EMPTYFILE);. Remove the data file from the database. REMOVE FILE datafile4;. Friday, November 18, 2011. Log Shipping VS Mirroring. Data Transfer: T-Logs are backed up and transferred to secondary server. Transactional Consistency: All committed and un-committed are transferred. Server Limitation: Can be applied to multiple stand-by servers. The pr...

sqldbastuff.blogspot.com

SQLDBA

Wednesday, April 20, 2011. Last execution date/time of DBCC CHECKDB. Execute the below query to check when was the last time DBCC CHECKDB has ran on all the Databases. CREATE TABLE #temp (. Id INT IDENTITY(1,1),. EXECUTE SP MSFOREACHDB'DBCC DBINFO ( '? SELECT [Value],ROW NUMBER() OVER (ORDER BY ID) AS rn1 FROM #temp WHERE Field IN ('dbi dbname'). CHECKDB2 AS ( SELECT [Value], ROW NUMBER() OVER (ORDER BY ID) AS rn2 FROM #temp WHERE Field IN ('dbi dbccLastKnownGood'). FROM CHECKDB1 JOIN CHECKDB2. Handy Dyn...

sqldbasupport.com

sqldbasupport.com Is For Sale

The domain sqldbasupport.com. Is for sale. To purchase, call BuyDomains.com at 339-222-5115 or 866-846-5160. Click here for more details.

sqldbasupport.wordpress.com

SQL DBA Support . COM - Knowledge Centre for SQL DBAs | By AMIT VAID, MS-SQL Database Administrator

SQL DBA Support . COM – Knowledge Centre for SQL DBAs. 124; Comments RSS. Admn – DBCC Commands. Feature – SQL Server 2005 and 2008. Interview Q and A. Perf – OS Level. Perf – Performance Monitor. Become a member of the SQLDBASupport community and receive notifications of new posts by email. Join 77 other followers. Sql at dbasupport dot in. File Allocation Unit Size – A Myth. Posted on February 28, 2015. The overall meaning of Allocation Unit Size in brief is…. Continue reading →. 124; Leave a comment.

sqldbatrainer.com

SQL DBA Trainer | SQL DBA Training | Oracle DBA training | SQL server dba Training

Are you looking to make a career move that give you stability and great income? Are you looking for a stable IT career? That has a long term outlook, then becoming a SQL DBA may be the right career move for you. SQL DBA as a career! Top 10 reasons report. According to Bureau of Labor Statistics, Database Administrator jobs have a 31% growth. Compared to 14% growth in other categories. The current install base of SQL server. At SQL DBA Trainer. We provide online / in class training.