SQL Server database encryption is one critical step to securing your database and keeping your organization out of the news for the wrong reasons. Unfortunately, implementing SQL Server Transparent Data Encryption can be extremely costly...
Learn about new functions in SQL Server 2016 and 2017 to have more readable and compact code including STRING_AGG, TRIM, TRANSLATE and DROP... IF EXISTS.
In this tip we cover the steps you need to follow to upgrade or migrate an existing SQL Server failover cluster and still use the same virtual network name and virtual IP address.
If a project, responsibility, accomplishment or technology is listed on your resume OR on the job description or list of requirements, you should be prepared to answer open-ended or pointed questions on. Learn some tips to get your prepared...
In this tip we look at how we can make SQL Server agent alert notifications smarter and more flexible to meet specific needs instead of the same generic alerting process for all alerts.
In this tip we look at a few examples of using .NET code to update and select data from SQL Server tables by creating a simple application and connection string to the SQL Server database.
In this tip we look at somethings to consider if you are thinking about freelancing as a SQL Server professional if you are in between jobs or ready to make the move to being self-employed.
