Introduction Microsoft announced in September 2018 that SQL Server 2019, which is now in preview, will have a Big Data Cluster deployment option. This is a Big-Data-capable SQL Server with elastic scale and extended Artificial Intelligence (AI) capabilities, mostly as a result of deep integration of Hadoop and Spark out-of-the-box. The new SQL Server Big […]
Gail Shaw issues a rallying call for the SQL Community to adopt the Scientific Method when investigating and reporting on SQL Server behavior.
Greg Moore demonstrates how to work with the Get-Credential PowerShell cmdlet and secure strings when authenticating to an SFTP server.
Kathi Kellenberger explains how to avoid build problems, when working with set of inter-dependent databases, by restoring or provisioning copies of all required databases to the development, build, or test instance.
When I decided to switch careers about 25 years ago, I had no idea how far I would go in tech. I just wanted to leave the profession for which I had trained and become a developer. My goal was to make the switch by the end of 1998. It actually happened in the summer […]
A look at SQL-On-Hadoop systems like PolyBase, Hive, Spark SQL in the context Distributed Computing Principles and new Big Data system design approach like the Lambda Architecture.
Today we have a guest editorial from Andy Warren that looks at the costs associated with our behavior.
In this tip we look at a way to stop the execution of a SSIS data flow task that is running by executing an outside process to stop the data flow immediately.
What if you have several people in the team who are responsible for data security across your databases, and they need to work together to develop and maintain the data masking configurations, which must then be applied consistently as part of an automated provisioning process? How should they do it? The solution turns out to be simple: source control.
Always Encrypted is a new security feature which was introduced in SQL Server 2016. Always Encrypted is a technology to ensure the data stored in a database remains encrypted at all times during SQL Server query processing. Always Encrypted allows clients to encrypt sensitive data, such as credit card numbers and national identification numbers, inside the […]
In my home lab I have an Ubuntu virtual machine that runs both SQL...
By Arun Sirpal
I am not sure when this became available but for Azure SQL Database 150...
When studying Azure one of the things you’ll be asked to learn is the...
Comments posted to this topic are about the item Is Data the Future of...
Hi, How do you share execution plans. Save the plan and share the .sqlformat...
I'm using AlwaysOn synchronous replica. User issues an update on primary via SSMS. In...
Ask SSC