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...
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. Read to learn some tips to get your prepared for th
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.
In this tip I'm going to discuss the three types of functions in SQL Server and what the next version does to address scalar UDF performance specifically.
