Category Archives: System/DB Administration

SQL Server wait states

Posted on April 29, 2015 by pfb_admin

The SQL Server Wait Type Repository… http://blogs.msdn.com/b/psssql/archive/2009/11/03/the-sql-server-wait-type-repository.aspx Wait Stats @ BrentOzar.com Safety Precautions for Kamagra Although cheap, Kamagra is perfectly safe for consumption. levitra prescription on line Stress, heart disorder, informative web-site viagra usa price depression and high cholesterol are … Continue reading →

Posted in SQL Server, System/DB Administration | Leave a comment

The catch with ClickOnce

Posted on March 4, 2015 by pfb_admin

ClickOnce is a great technique for in-house application distribution. It eliminates a lot of common problems for IT by giving users the ability to control their own application installs and updates. However, relinquishing tight control has some very significant downsides. These are … Continue reading →

Posted in Programming, System/DB Administration | Leave a comment

Analyzing queries

Posted on January 28, 2015 by pfb_admin

I’m sure someday I’ll want this but won’t be able to find it again. So, this goes out to my future self:  https://msdn.microsoft.com/en-us/library/ms191227.aspx Analyzing a Query The SQL Server Database Engine can display how it navigates tables and uses indexes to access … Continue reading →

Posted in SQL Server, System/DB Administration | Leave a comment

SQL Server Managment Studio (free) download

Posted on October 24, 2014 by pfb_admin

My workplace uses SQL Server 2005 to host the app for which I’m respsonsible. The ISV only certified SQL Server 2008 in their most recent version, so we’re really not lagging much. However, I try to keep my tools in line with the production … Continue reading →

Posted in SQL Server, System/DB Administration | Leave a comment

Synchronicity, serendipity, and Server service schedules

Posted on October 3, 2014 by pfb_admin

Background: For the past year, I have been receiving nightly administrative monitoring messages from our production database. A recent project required a nightly quality check with associated alert. I used a technique similar to the well-proven monitoring messages, and after careful testing … Continue reading →

Posted in Business, Programming, Project Management, SQL Server, System/DB Administration | Leave a comment

Mixed links: Powershell

Posted on August 4, 2014 by pfb_admin

http://technet.microsoft.com/en-us/library/hh848797.aspx  List of topics http://technet.microsoft.com/en-us/library/ff730951.aspx plus ACL http://technet.microsoft.com/en-us/library/ff730950.aspx Multi-select list boxes… SO CLOSE! http://technet.microsoft.com/en-us/library/ff730938.aspx Click OK to continue… http://technet.microsoft.com/en-us/library/ff730959.aspx Scripting for multiple computers http://technet.microsoft.com/en-us/library/ff730964.aspx Working with environment variables Added later: http://windowsitpro.com/windows/create-your-own-powershell-functions PS Functions If discount viagra frequent urination occurs, the amount … Continue reading →

Posted in Programming, System/DB Administration | Leave a comment

Pro-active DBA link

Posted on December 3, 2013 by pfb_admin

Summed up nicely. http://www.sqlservercentral.com/Forums/Topic1494961-3411-1.aspxWHAT IS A on line cialis? cialis is a product which increases the flow of blood into the male organ, resulting in stronger erection and improved sexual performance. Q- Hope through researchAns- Advances in suppositories, inject able … Continue reading →

Posted in SQL Server, System/DB Administration | Leave a comment

Change Data Capture pattern

Posted on November 27, 2013 by pfb_admin

We’re having a problem with ETL between our ERP and MES systems. We use a timestamp-based periodic export. It occasionally skips a record. We have determined this is due to the duration a transaction is open. If an export occurs … Continue reading →

Posted in Business, Programming, SQL Server, System/DB Administration | Leave a comment

High Availability with SQL Server and Double-Take – the links

Posted on November 11, 2013 by pfb_admin

In 2008, Steve Warren with TechRepublic created a 3-part blog post with details of how to configure Double-Take software to protect SQL Server. The 3 parts are not mutually linked to each other. Here are links to all three parts: Part … Continue reading →

Posted in Programming, SQL Server, System/DB Administration | 1 Comment

T-SQL to Determine size of transaction log file

Posted on November 8, 2013 by pfb_admin

–http://blog.sqlauthority.com/2010/02/08/sql-server-find-the-size-of-database-file-find-the-size-of-log-file/ –SQL SERVER – Find the Size of Database File – Find the Size of Log File –Reference: Pinal Dave (http://blog.SQLAuthority.com) SELECT DB_NAME(database_id) AS DatabaseName, Catalogue modeling is also specific to where you live, it’s very purchase cheap cialis https://drscoinc.com/cialis-1023.html … Continue reading →

Posted in SQL Server, System/DB Administration | Leave a comment