sqldbamusings.blogspot.com
SELECT info FROM blogs WHERE category IN ('SQL', 'Powershell', 'SMO')
SELECT info FROM blogs WHERE category IN ('SQL', 'Powershell', 'SMO'). Tuesday, October 23, 2012. Two Thousand Five Hundred Sixty. Seems like such a random and unassuming number, however, I can say this was the most disturbing number on the spectrum of disturbing numbers over the past few weeks. The numbers 13 and 666 were child’s play compared to the stress that 2,560 created. What was this number you say? Letting me know that I had passed one of the most feared exams in the SQL Server community –...
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|t-sql | sharepoint | microsoft business intelligence| SSAS| SSIS | SSRS onlien training
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.
