Load and run custom T-SQL scripts in SSMS via Snippets
If you work with SQL Server on a daily basis, it is very likely you have a lot of custom...
2018-11-12
288 reads
If you work with SQL Server on a daily basis, it is very likely you have a lot of custom...
2018-11-12
288 reads
If you work with SQL Server on a daily basis, it is very likely you have a lot of custom scripts you have to execute frequently, maybe you have...
2018-11-12
3 reads
R Services (SQL Server 2016) or Machine Learning Services (2017 and 2019 CTP) provide you with the ability to perform...
2018-11-08
1,098 reads
R Services (SQL Server 2016) or Machine Learning Services (2017 and 2019 CTP) provide you with the ability to perform data analysis from the database itself using T-SQL.You can...
2018-11-08
2 reads
PowerBI is a powerful reporting solution for Business Intelligence for analytical reports, it is not meant to replace SSRS, the...
2018-10-16 (first published: 2018-10-03)
2,955 reads
Transparent data encryption (TDE) helps you to secure your data at rest, this means the data files and related backups...
2018-10-15
225 reads
Transparent data encryption (TDE) helps you to secure your data at rest, this means the data files and related backups are encrypted, securing your data in case your media...
2018-10-15
3 reads
PowerBI is a powerful reporting solution for Business Intelligence for analytical reports, it is not meant to replace SSRS, the focus of this tool is to be able to...
2018-10-03
2 reads
On a previous post, we discussed what is an extended event (XE) and how to create one.
With the following T-SQL...
2018-10-03
221 reads
On a previous post, we discussed what is an extended event (XE) and how to create one.With the following T-SQL you can quickly check what are the currently running...
2018-10-03
8 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers