Tag: encryption

Pro Members SQL Server Standard Members

Tips for using views in SQL Server 2019

Tips for using views in SQL Server 2019 Use views instead of heavy-duty queries to reduce network traffic. Using views instead of heavy-duty queries can reduce network traffic, because your clients will send to server only a simple query, such as SELECT * FROM VIEW_NAME (perhaps with some parameters), instead of large heavy-duty queries text. Consider using stored procedures instead...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Editorials Security SQL Server

TIL: Columnar Encryption Might Be Susceptible to Abuse

I was reading a post talking about some SQL encryption technologies and statements (because, you know, that’s what I do just sitting around…) and found a new potential vulnerability that I’d never really considered before. I don’t pretend that I know *all the things* about security and encryption – it’s a constant process to keep learning and figuring out what […]

Editorials

Database Connection Encryption

A high priority for developers working with SQL data stores is to establish a way to access our Database without exposing our credentials. We want to protect our application from Hackers and hide the methods to establish a connection… This can be a bit of a problem with the most common method of establishing a database connection for our application […]

Pro Members SQL Server Standard Members

Microsoft SQL Server security best practices checklist – Part -2

Microsoft SQL Server security best practices checklist – Part – 2 Author: Basit A. Farooq Editor’s Note: This is the second part of my two part article series on SQL Server security best practices. SQL Server Administration Avoid managing SQL Server instances using sa or any other SQL login account that has been granted CONTROL SERVER permission, or is a...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 database settings

Tips for using SQL Server 2012 database settings To change the database settings, you can use the ALTER DATABASE SET Options or you can use the graphical user interface (GUI). To change the database settings using GUI, you can do the following: – In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

SQL Server Encryption Options – Part 2

SQL Server Encryption Options – Part 2 Author: Basit A. Farooq Editiors Note: In the first part of this article series, I discussed the options for encrypting connections and learn concepts on how to encrypt confidential data in the database. In this second part, I will show you how to encrypt data using cell-level encryption, and how to encrypt database...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

SQL Server Encryption Option – Part 1

SQL Server Encryption Options – Part 1 Author: Basit A. Farooq Many database servers store confidential data, which must be protected from unauthorized access when it’s transmitted across the network and stored on the server. SQL Server provides support for encrypted connections, encrypting data, encrypting database and for encrypted storage. In this first part of this article series, I’ll discuss...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Editorials Encryption/Data Security

Metro? What Is Behind It All?

SSWUGtv – SQL Server 2012 With Stephen Wynkoop In todays edition Steve interviews Gareth Swanepoel. Gareth talks about SQL Server 2012, extended events wizard and interface – how to performance tune, and more. Watch the Show Metro – What Is Behind It All? I’d like to wrap up my concerns about the Metro design principles with another epistle from David […]

Editorials Encryption/Data Security

Windows Metro ? The Lowest Common Denominator

Windows Metro – The Lowest Common Denominator The title is to get your attention. The fact is that Windows Metro will not necessarily be the Lowest Common Denominator anymore than other devices supporting tablet/smart phone style manipulations, primarily touch screens. Many good hardware devices are designed around the Android OS, which the Metro look and feel appears to emulate in […]