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 […]
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.
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 […]
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 :-)
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 […]
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 […]
In a real world scenario, we can sale in our online store on standard or discounted prices. In this exercise we use three tables to demonstrate the zig-zag JOIN:
I am very happy to announce that my first book, dedicated to Microsoft SQL Server from the Learn Intuitively series is now on KickStarter.
When we write a DML query that is using JOINed tables as data source, first we need to understand the way SQL Server is manipulating the data. The clauses in the DML query statement are ordered as follows: SELECT FROM… JOIN WHERE GROUP BY HAVING ORDER BY Behind the scene […]
When we create dynamic SQL code, we can add the parameters in two ways: Concatenate them into the dynamic code with + Use sp_executesql