Introduction to SQL Server Security — Part 1
Security is often considered the most important of a database administrator's responsibilities. SQL Server has many powerful features for security and protecting data, but planning and effort are required to properly implement them. In this article, the first of a series, Robert Sheldon reviews the many components available to secure and protect SQL Server databases.
Introduction to Microsoft R Services in SQL Server 2016
General introduction to R Services in SQL Server 2016 and how R server works with external stored procedure.
Your Recovery Time
Disaster recovery is one of those situations that we plan for and hope we never experience. Are you prepared?
Query Store And Cruel Defaults
Erik Darling loves query store, but he really hates the default capture mode.
Fast Enough
The RDBMS works great for many situations, but is it ever fast enough to meet all your needs?
Rolling Back CREATE DDL Statements
There is a myth that DDL statements can't be rolled back. This article tests and debunks the myth.
Getting Started with CQRS – Part 2
In this second article of the series, Diogo Souza walks you through creating the MongoDB code, the query side of the pattern, to complete the CQRS configuration.
Faster Cloud Warehouses
Azure SQL Data Warehouse gets some improvements, and Steve has a few comments.
SQL Server Reporting Services Report Builder with DAX Query Support
In this tip we look at how you can use DAX formulas within your SQL Server Reporting Services Report Builder reports.
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers