Category Archives: SQL Server

Simple SQL to count related records

Posted on August 18, 2021 by Eric Weberg

Here is a basic example of how to use a subquery to return a total count of records. This is particularly useful to show an aspect related to some info that you are working with. This example would count the … Continue reading →

Posted in Programming, SQL Server | Leave a comment

Updating nullable DataTable columns

Posted on October 28, 2020 by pfb_admin

While NULL is a standard feature and business-as-usual in the SQL world, and likewise null objects are common in the C# world, the concept of NULL and null are completely different things and the translation is easily forgotten. This is … Continue reading →

Posted in C#, Programming, SQL Server | Leave a comment

Sort a DataTable

Posted on July 20, 2018 by pfb_admin

I first noticed this technique here: https://www.codeproject.com/Questions/219205/How-To-Sort-Datatable-in-csharp-net More Juicy goodness here: https://social.msdn.microsoft.com/Forums/vstudio/en-US/87a64069-e78c-4930-a751-d2be7f1e7b50/how-to-sort-datatable?forum=csharpgeneral   private void FillSessionChecklistboxForAttendees(CheckedListBox clb, string session_id) { MesQueries.TrainingAdmin ta = new MesQueries.TrainingAdmin(_mq); ta._queryMode = MesQueries.TrainingAdmin.QueryModes.AttendeesForSession; ta.session_id = session_id; DataTable dtAttendees = _mq.GetContentDataTable(ta); Creativity is simply at the bay … Continue reading →

Posted in C#, Programming, SQL Server | Leave a comment

Linkdump: DBA: DBs + SCS

Posted on May 11, 2018 by pfb_admin

Databases and Sourcecode Control Systems https://www.red-gate.com/hub/product-learning/sql-source-control/strategy-implementing-database-source-control Synch and compare DBs How to automatically compare and synchronize SQL Server data Azure getting started demo: https://azure.microsoft.com/en-us/get-started/webinar/?mkt_tok=eyJpIjoiWkdZM056azFZVEUwTWpKaiIsInQiOiJmeDlnd3ZUWlwvNTZFemlQb3VNQzJkZHhLWFRidnR4QllzcmxrN011ajBUMWRCdUxoUDhcL2VjbDNPN3dneTdnZ1lUZ0JmeUNBanRCZmpyUFhmVUxIWmxkMk1ka2tIb0I0RVwvZ2Z5UmdPRnlZd1wvclFuU2Q1dFNxOW5GQUg2bnNkSlhJNFpwYjUxSVwvbHZ5VUJHdmg3bVl6RUVjdnV2NmVjTjRnVkFsaVJGbmxoST0ifQ%3D%3D Price This is what sets the tone for the type of customers that a business is … Continue reading →

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

Hazards of SQL SELECT DISTINCT

Posted on April 24, 2018 by pfb_admin

Although SQL’s DISTINCT keyword creates a list of unique values like usernames or route steps, it’s dangerous in practice. It can: mask actual duplicates – which can mean entered data might be recorded under the wrong entry (or the right … Continue reading →

Posted in Programming, SQL Server | Leave a comment

Linkdump: BIML, BI, Elastisearch-Kibana, SS Interviews, Data protection

Posted on March 9, 2018 by pfb_admin

BIML Business Markup Language https://www.mssqltips.com/sqlservertutorial/9089/introduction-to-the-biml-language/ BI – Logi Analytics. Responsive design, Dashboard design https://www.logianalytics.com/art-responsive-design-dzone-archive/ http://go.logianalytics.com/webinar-art-of-dashboard-design.html?mkt_tok=eyJpIjoiTkRJMk56aGpNamd6TkRreiIsInQiOiJSM05kQXBCaTM2SzF5UVBDazhMVGhBdmlFSE1CYU5TdjRKWStPMVwvcktSdWk0RTV1djRLUm1kYU9Bc2xJT0NRVDJOZG9PWkVhOXoyb1VBcG1jQTNtMXZLMWk0VDc4a09IRzdOSlVuNzVDVGVBWE5xUDFzajFwUnpPMEJVczBqV1oifQ%3D%3D Helping your BI Consultant be successful:  http://www.sqlservercentral.com/blogs/data-savvy/2018/01/30/ten-ways-to-help-your-bi-consultant-be-successful/?utm_source=SSC&utm_medium=pubemail Vagrant Command line interface: https://www.vagrantup.com/docs/cli/ Elastisearch and Kibana Client guide: https://www.elastic.co/guide/en/elasticsearch/client/index.html Downloads: https://www.elastic.co/content-pack Getting started: https://www.elastic.co/webinars/getting-started-elasticsearch?baymax=rtp&elektra=docs&storm=top-video&iesrc=ctr Forums: https://discuss.elastic.co/?ultron=es-get-started&blade=touch&hulk=email&mkt_tok=eyJpIjoiTlRCak16WTVNalZrWVdFeSIsInQiOiIxR3BlcW5HZ3IxRDdrbytSRnZpZ3JOcTZaMlNoUkZoTGdFU3VWTU5FMTNDaW5LdzNLTG9VMHhpZm5jek9mVEhCdmNENEo3S3ZqSjJHS3U5RTJKM1JHRk1OaGh3bUdUdk82Tks3Z1YyaFwvVXdGOFwvXC9sR3dFQlBGbUI1aTRwUm5PUSJ9 SS Interview https://mohammaddarab.com/interview-aaron-bertrand/?utm_source=SSC&utm_medium=pubemail Moving … Continue reading →

Posted in Business Intelligence, Linkdump, Project Management, SQL Server | Leave a comment

Linkdump: Various learnings: SD, JS. SS/BI/BD

Posted on January 30, 2018 by pfb_admin

10 books every web developer should read to increase their software IQ Backtracking algorithmic approach: http://blog.dailycodingproblem.com/an-introduction-to-backtracking/?utm_campaign=News%20on%20Monday&utm_source=hs_email&utm_medium=email&utm_content=60133300&_hsenc=p2ANqtz-8wUu0X1MNw7Ka4qWf8k5TgFDmfpiT6ecVsss07oZuypsu4t3kozhxperXdqM_8hp9YYaZbrEcMBuo2C-2sH3Y7QNx1iGWGWHqcJCplbP3RRpSbZ5c&_hsmi=60133300 Javascript framework Comparison: https://javascriptreport.com/js-frameworks-fastest/?utm_campaign=News%20on%20Monday&utm_source=hs_email&utm_medium=email&utm_content=60133300&_hsenc=p2ANqtz-8wUu0X1MNw7Ka4qWf8k5TgFDmfpiT6ecVsss07oZuypsu4t3kozhxperXdqM_8hp9YYaZbrEcMBuo2C-2sH3Y7QNx1iGWGWHqcJCplbP3RRpSbZ5c&_hsmi=60133300 Inferno Javascript framework: https://infernojs.org And moreover they sell a segment cheap cialis http://www.solboards.com/cialis-1455.html of medicines which don’t need doctor’s prescriptions. … Continue reading →

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

T-SQL: Trim after newline / carriage return

Posted on January 18, 2018 by pfb_admin

USE [db_mes_sandbox] GO EXEC [dbo].[usp_CompleteHierarchy3] @pSerial_number = N’110160766′, @pFlag_IncludeCcaComponents = 0, @pFlag_IncludeReplacedParts = 0, @pDebug = 1 GO SELECT product_id ,name ,revision This misalignment is not really good for the baby’s development cialis 10 mg http://www.jealt.mx/cialis-8971 inside the womb because … Continue reading →

Posted in SQL Server | Leave a comment

Meltdown and Spectre patches, via SQLServerCentral

Posted on January 5, 2018 by pfb_admin

http://www.sqlservercentral.com/articles/SQL+Server/166822/?utm_source=SSC&utm_medium=pubemail  This is because of the fact that sildenafil ( levitra price in india), vardenafil (levitra), and levitra 10 mg (cute-n-tiny.com) all function by inhibiting PDE5, ‘s pharmacologic distinction is its extended fifty percent-everyday living (17.50 several hours) – in … Continue reading →

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

SQL Server diagnostics notes

Posted on December 15, 2017 by pfb_admin

This week’s amusement: performance of a recently-implemented Stored Procedure dropped and dropped to intolerable levels. This system cannot be easily upgraded. Significant fragmentation is involved. Memory pressure is involved. Inserts to table variables in multiple stored procs are involved. This … Continue reading →

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