sql defrag 

Managing your active SQL Server instance list using PHP

By: Graham Okely   |   Read Comments   |   Related Tips: More > Database Administration Problem What SQL Server instances do you manage?  What environment is each one in? Can you add or remove instances from your master list easily?  In this tip, we will look at a simple way to manage your list of SQL Server instances using PHP and SQL Server. Solution In this tip some PHP code is discussed to help you manage a list of…

Read More
sql defrag 

Locally Weighted Scatterplot Smoothing (Lowess) approach in Power BI

By: Esat Erkec   |   Read Comments   |   Related Tips: More > Power BI Problem How do apply the Locally Weighted Scatterplot Smoothing (Lowess) method and find out the trend of a data series in Power BI? Solution In some cases, linear regression cannot clarify relationships between variables and cannot detect the trend of a data series. For this reason, we can apply other regression methods in statistics. Locally Weighted Scatterplot Smoothing also known as the…

Read More
sql defrag 

6 Ways to Add Value to Your LinkedIn Network

By: Cate Murray   |   Read Comments   |   Related Tips: More > Professional Development Branding Problem Are you new to LinkedIn or revamping your profile to be more attractive, detailed, and credible to potential employers?  On the other hand, are you simply trying to be more active so you stay better connected with your network? If so, it is important to understand how easy it is to add value to your LinkedIn network, and why you should take…

Read More
sql defrag 

How to Query Arrays, Hash Tables and Strings with PowerShell

By: Tim Smith   |   Read Comments   |   Related Tips: More > PowerShell Problem When we develop solutions that require identifying what data we have or don’t have, we will sometimes require an ability to query sets, definitions or find prior to conversion. For these use cases, we may use objects like arrays, hash tables and strings. The use case of these objects can stretch beyond these requirements, though these requirements provide a useful example of how we…

Read More
sql defrag 

Script to Retrieve All Error Numbers and Messages from the SQL Server Error Log

By: Eduardo Pivaral   |   Read Comments   |   Related Tips: More > Monitoring Problem The undocumented function xp_readerrorlog provides us the ability to read the SQL Server error log using T-SQL and perform some basic text searches, but this function is very limited.  For example, if we want to retrieve the error number and related message, since they are located on different rows, and a text search won’t work on those cases. First, let us see how…

Read More
sql defrag 

Create Tabular Model Sample from SQL Server Database – Part 1

By: Haroon Ashraf   |   Read Comments   |   Related Tips: > Analysis Services Development Problem As a SQL Server business intelligence developer, I would like to work directly on a tabular analysis services project using a SQL database sample which must comply with data warehouse sample requirements.  How can I prepare a database to be used for tabular analysis? Solution The solution is to convert a SQL database sample into a tabular model sample by making…

Read More
sql defrag 

Implement a Slowly Changing Type 2 Dimension in SQL Server Integration Services – Part 1

By: Koen Verbeeck   |   Read Comments   |   Related Tips: More > Integration Services Development Problem We’d like to keep history in our data warehouse for several dimensions. We use SQL Server Integration Services (SSIS) to implement the ETL (Extract Transform and Load). We tried the built-in Slowly Changing Dimension wizard, but the performance seems poor. How can we implement the desired functionality with regular SSIS components? Solution Introduction to Slowly Changing Dimensions A slowly…

Read More
sql defrag 

Understanding SQL Server Connection Pooling in ADO.NET

By: Artemakis Artemiou   |   Read Comments   |   Related Tips: More > Application Development Problem This tip will help you to better understand what connection pooling is in the data access world. Also, after reading this tip, you will have more knowledge on how to take advantage of the connection pooling mechanism when writing .NET data access code that communicates with SQL Server. Solution In its simplest explanation, a connection pool is a cache of database connections.…

Read More
sql defrag 

Linear Regression with Python in SQL Server 2017

By: Siddharth Mehta   |   Read Comments   |   Related Tips: More > Python Problem The fundamental process in the machine learning development life cycle is identifying the dependent and independent variables for developing a data model. The two basic categories of supervised machine learning are classification and regression. Regression is arguably the most basic form of machine learning algorithms and suitable for beginners in machine learning. Though it is one of the most basic algorithms for machine…

Read More
sql defrag 

Simple Free Disk Space HTML report for SQL Server

By: Diogo Souza   |   Read Comments   |   Related Tips: More > Monitoring Problem Automated SQL Server database monitoring is a very important task for the DBA, because information about the availability and health of the environment (instances availability, use of data files and transaction logs, resource consumption: CPU, disk and memory, etc.) is obtained when the professional is not in his or her working hours. Obviously, this data is used to alert the administrator of a problem…

Read More