T-SQL: UDF Scalar Function to Clean Multiple Spaces
While working on autocomplete dropdown, i created a simple scalar function that replaces multiple spaces with one.
PowerShell: List Installed Software on Local Computer in .CSV File
I had to collect the installed software from few computers and i used Belarc Advisor. The fun came when i started to consolidate the data :-) To make my future life easier, i wrote a PowerShell script that exports a list of the installed programs into .CSV file. Here it […]
T-SQL: (Migration) Export the definition of Stored Procedures
Very often we need to bulk export database objects and move them to another server. Manually we do this by right click on the database –> Tasks –> Generate Scripts… In this example I show how we can export Stored Procedures with T-SQL and SQLCMD. This model gives us the […]
Fill in this short quiz to get your FREE Learn SQL Server Intuitively eBook
Complete our survey and we’ll send you your FREE Learn SQL Server Intuitively eBook. This is our THANK YOU for you. Keep it simple :-)
T-SQL: UDF Scalar Function to mask Credit Card numbers
We usually mask the credit card number in reports or end user data with asterisk (*). Here I show a scalar-valued function that masks the Credit Card Number.
Training: SQL is the top demanded programming language
Few days ago Business Insider posted a list of 8 in-demand programming languages. The big news is that SQL is number 1! Codingdojo report spots SQL as the best programming language to learn, based on the number of job postings on Indeed. Finally I decided to check the average salary for SQL Developer […]
Training: The Kindle version of Learn SQL Server Intuitively. Transact-SQL: The Solid Basics is on Amazon
As of today, after a one year and a half long process of writing and preparing, the book that gives you the solid basics in Transact-SQL Learn SQL Server Intuitively. Transact-SQL: The Solid Basics is now on Amazon in Kindle format. Select your market: USA Canada Great Britain Australia Germany […]
Tools: SQL Sentry Plan Explorer is completely FREE for everyone
There is a great news today for SQL Server community – SQL Sentry (RSS: SQLPerformance.COM) Plan Explorer is FREE for everyone. Download User Guide Thank you, SQL Sentry! Keep it simple :-)
T-SQL: NVARCHAR(255) vs. NVARCHAR(MAX) Disk Space Comparison
In some scenarios like ETL or load data into a DB, we need to insert the data into a staging table, where all the columns are String data type and on the next step to cleanse and manipulate the data. I heard a discussion about the data type of the […]
FREE Webinar to present Learn SQL Server Intuitively. Transact-SQL: The Solid Basics 1
A FREE webinar that will present Learn SQL Server Intuitively. Transact-SQL: The Solid Basics book and will teach you how to: create tables, insert, update and delete data into them select data from existing tables aggregate data will take place Sat, Aug 13, 2016 10:00 AM – 11:00 AM Eastern Daylight Time […]