Category Archives: SQL Server

Clone programming steps

Posted on September 15, 2017 by pfb_admin

— list products that might need to be programmed. SELECT name,revision, product_id FROM qs_products where name like ‘277000-200-%’ — list current programming steps select p.name,p.revision,steps.* from [dbo].[ACA_swprg_programming_steps] steps INNER JOIN qs_products p ON p.product_id = steps.mes_product_id — after updating the … Continue reading →

Posted in SQL Server | Leave a comment

Populate NULL component_ids from related tables

Posted on September 13, 2017 by pfb_admin

Needed to populate a new column in one table from a semi-related existing table, based on a value in another related table. I do this once in a blue moon and needed a refresher. Thanks, Pinal Dave, for your post … Continue reading →

Posted in SQL Server | Leave a comment

Linkdump: SQL Server T-SQL tips and tricks

Posted on July 12, 2017 by pfb_admin

SQL Server Row Count for all Tables in a Database https://www.mssqltips.com/sqlservertip/2537/sql-server-row-count-for-all-tables-in-a-database/ One of several techniques posted by Dattatrey Sindo: SELECT QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + ‘.’ + QUOTENAME(sOBJ.name) AS [TableName] , SUM(sPTN.Rows) AS [RowCount] FROM sys.objects AS sOBJ When this condition goes uncheck, … Continue reading →

Posted in Linkdump, SQL Server | Leave a comment

Linkdump: Docker, Puppet, SQL Server hosting

Posted on July 12, 2017 by pfb_admin

http://www.sqlservercentral.com/blogs/the-database-avenger/2017/06/13/orchestrating-sql-server-with-kubernetes/?utm_source=SSC&utm_medium=pubemail http://www.sqlservercentral.com/blogs/the-dba-who-came-in-from-the-cold/2017/06/14/changing-default-location-for-docker-containers/?utm_source=SSC&utm_medium=pubemail https://www.red-gate.com/simple-talk/sysadmin/containerization/overcoming-challenges-microservices-docker-containerisation/?utm_source=DBW&utm_medium=pubemail Not all online storefronts are reputable and reliable, and when you get to levitra generika know about this issue and not to forget the fact that you will require proper guidance from the doctor and proper suggestions … Continue reading →

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

Onboarding tasks: SQL Server

Posted on July 12, 2017 by pfb_admin

https://www.mssqltips.com/sqlservertip/4871/sql-server-dba-onboarding-checklist/  It controls bad cholesterol levels and cialis canada rx protects against heart disease. Yes, these pills are safe and apart from a few minor side-effects, you will be able to make the most out of this situation are Cheap … Continue reading →

Posted in Business, Linkdump, SQL Server | Leave a comment

How to Read the Transaction Log File

Posted on July 12, 2017 by pfb_admin

Whoa, nice. How to Read the Transaction Log File Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file?  Well there is a way to read the transaction log file … Continue reading →

Posted in Linkdump, SQL Server | Leave a comment

Kendra Little’s free SQL Server training webcasts

Posted on July 12, 2017 by pfb_admin

New Free Webcasts on One can buy Tadalafil Online as it is available at its cheapest rate at the online drug stores and there are many online outlets to buy Shilajit capsules. prescription levitra Its exact cause is yet to … Continue reading →

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

Phil Factor @ SimpleTalk: Statistics in SQL: Pearson’s Correlation

Posted on June 9, 2017 by pfb_admin

Statistics in SQL: Pearson’s Correlation The series so far: Statistics in SQL: Pearson’s Correlation Men who use buy pill viagra recreational substances may experience the same problem, and in some cases, use of certain chemicals that are either produced within … Continue reading →

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

RedGate: VMWare monitoring in SQL Monitor

Posted on June 9, 2017 by pfb_admin

VMware monitoring in SQL Monitor  Sudden loss of penile erection can be a scary, cialis on sale troubling, and downright humiliating thing. Conclusion The answer to the question – getting viagra prescription “Do libido pills for men work?” would be … Continue reading →

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

Database unit testing resources

Posted on May 18, 2017 by pfb_admin

Not strictly a linkdump, but a list of Regular use of this herbal pill improves the blood supply to the reproductive organs. continue reading to find out more now tadalafil generic cheapest Since generic buy uk viagra drugs are made … Continue reading →

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