Preparing SQL Servers and Data for Quantum Computing
Quantum computing, when fully realized, will have a significant impact on encryption and the data stored in SQL Server databases.
Brian Kelley is an author, columnist, Certified Information Systems Auditor (CISA), and former Microsoft Data Platform (SQL Server) MVP (2009-2016) focusing primarily on SQL Server and Windows security. Brian currently serves as a data architect as well as an independent infrastructure/security architect concentrating on Active Directory, SQL Server, and Windows Server. He has served in a myriad of other positions including senior database administrator, data warehouse architect, web developer, incident response team lead, and project manager. Brian has spoken at 24 Hours of PASS, IT/Dev Connections, SQLConnections, the Techno Security and Forensics Investigation Conference, the IT GRC Forum, SyntaxCon, and at various SQL Saturdays, Code Camps, and user groups.
- MSSQLTips Awards: Author of the Year Contender - 2015, 2017 | Champion (100+ tips) - 2014
Automating SQL Server Builds
Learn how you can automate SQL Server builds using PowerShell, SQLCMD and SQL queries to setup SQL Server and install databases.
Microsoft SQL Server Sample Databases
Learn about and how to get the SQL Server sample databases Northwind, Pubs, AdventureWorks, and WideWorldImporters.
SQL Server Static Data Masking with DataVeil
Learn how to use production-like data for testing and development, but mask sensitive data quickly and efficiently with DataVeil.
Implementing SQL Server Security with Stored Procedures and Views
Learn about how ownership chaining allows you to limit permissions on specific database objects yet give users access through other objects such as views and stored procedures.
Understanding SQL Server Ownership Chaining
In this article we look at an example of SQL Server ownership chaining to better understand how permissions are passed through objects.
Dealing with a No NULL Requirement for Data Modeling in SQL Server
In this article we look at two different approaches to storing data in a SQL Server database when NULL values are not an option.
Skip-2.0 Malware Impacts SQL Server – Should I Be Worried?
There's a new piece of malware named skip-2.0 and it targets SQL Server. In this article learn what is it, where it came from, and how to protect your SQL Servers.
SQL Server Implicit Conversions Performance Issues
In this tip we learn about implicit conversions that occur in SQL Server. We will look at an example, how to fix and also how to detect using extended events.
SQL Server Forensics Analysis Based on Database Backup Size
In this tip we look at ways to narrow down when a big transaction event occurred in SQL Server based on the default trace and backup sizes.
Statement Backup Log is Not Allowed for a SQL Transaction Log Backup
In this tip we look at why SQL Server transaction log backups fail if the database is not in the correct recovery mode.
Data Modeling: Understanding First Normal Form in SQL Server
In this tip we take a look at understanding what first normal form is for data modeling and how it applies in SQL Server.
Understanding and Using SQL Server sys.dm_exec_requests
In this tip we look at SQL Server sys.dm_exec_requests and various ways to use this to find active requests from connected users and applications.
Understanding and Using sys.dm_exec_sessions in SQL Server
In this tip we look at how we can use SQL Server DMV sys.dm_exec_sessions to see what sessions are doing in SQL Server.
Return SQL Server Connection Information with sys.dm_exec_connections
In this tip we look at we can use SQL Server DMV sys.dm_exec_connections to see what current connections are doing for troubleshooting and monitoring.
Application Database Security Design Part 2 – Multiple Levels of Access to SQL Server
In this tip we will look at the situation where a SQL Server database application requires multiple access levels with respect to accessing and modifying the data and how this can be done.
Script to find failed SQL Server Backups and validate re-running code was successful
Check out this tip to help you figure out what SQL Server Agent Backup Jobs are still a problem.
Audit SQL Server Logins without filling up the Error Log
Check out this tip to learn how to use the Audit object to audit SQL Server logins.
Auditing for New SQL Server Agent Jobs
In this tip we cover several scripts that can be used to audit for new SQL Server Agent jobs.
Is disabling xp_cmdshell in SQL Server really secure?
In this tip we learn whether disabling xp_cmdshell in SQL Server really improves security.
Protecting SQL Server from Ransomware
Learn how to protect your SQL Server from ransomware with these tips.
Practice of Using Privileged Accounts to Access SQL Server
In this tip we will cover why it is important to have separate accounts for normal use and for administrative use.
Verify Connectivity to SQL Server
Check out this tip to learn about different ways to check SQL Server connectivity issues.
Application Security Design – Part 1 – Authentication for SQL Server
In this tip we look at best ways to architect and design SQL Server security authentication.