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.
2020-10-01
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how ADS works, shown here: Getting Started with Azure Data Studio Getting Comfortable Writing Code in Azure Data Studio Using Notebooks in Azure Data Studio Using Azure Data Studio with TFVC Using Azure Data Studio with […]
2020-09-30
19,204 reads
This tip provides a step by step process to create a cross tabulation report in SQL Server Reporting Services.
2020-09-30
You are invited to discover features of SQL Prompt that you may not even know exist. We will will walk you through the treasure map of SQL Prompt and show you where all the great features are buried.
2020-09-30
Phil Factor offers straightforward answers to tricky SQL Compare questions.
2020-09-30
A colleague left the company, a couple of days after SQL Server processes start failing...what do you do?
2020-09-29
6,274 reads
While everyone knows SQL Prompt for its code completion and IntelliSense features, a lot of its extra value comes from features that allow the development team to standardize coding practices and drive up code quality.
2020-09-29
Containers are being used by more and more organizations to automate build pipelines in their CICD processes. In this article, Mahendran Purushothaman shows how to automate the creation of Docker containers and a Kubernetes cluster in Azure.
2020-09-29
Introduction to PostgreSQL PostgreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language. Though originally designed to run on UNIX platforms, PostgreSQL is eligible to run on various platforms such as Linux, macOS, Solaris, and Windows. PostgreSQL databases provide enterprise-class database solutions and are used by […]
2020-09-28
6,567 reads
In my last post, I talked about how you can get 43%-67% faster backups. This time, I’m using that same SQL Server setup to discuss how throwing more CPU cores might help you check for corruption faster if you’ve already got modern fast storage.
2020-09-28
By Steve Jones
I had someone reach out about generate_series() recently, saying they hadn’t realized this was...
I recently took and passed the DP-700 exam, which is required for the Microsoft...
As a Consultant, I would typically answer with – it depends! Then a typical...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Comments posted to this topic are about the item How to Download and Restore...
Comments posted to this topic are about the item Tracking Table Sizes
What does this code return in SQL Server 2022+?
select bit_count(2.4)See possible answers