Summarizing data using GROUP BY and HAVING clauses
SQL Server provides the GROUP BY clause as a means to take a set of detailed values […]
SQL Prompt
The VALUES clause or building tables out of nothing
The VALUES clause is probably one of the most misused features in SQL. If you look at […]
SQL Prompt ALT S Magic
The post SQL Prompt ALT S Magic appeared first on SQLServerCentral.
Exploring Auto-fix in SQL Code Analysis
The post Exploring Auto-fix in SQL Code Analysis appeared first on SQLServerCentral.
A UNIQUE experience
If you look at the postings on SQL forums, you will notice that people are sloppy. They […]
Managing, Editing and Comparing SQL Code Analysis Settings
The post Managing, Editing and Comparing SQL Code Analysis Settings appeared first on SQLServerCentral.
How to Compare Two SQL Prompt Styles
The post How to Compare Two SQL Prompt Styles appeared first on SQLServerCentral.
Creating and Maintaining a SQL Code Snippet Library
The post Creating and Maintaining a SQL Code Snippet Library appeared first on SQLServerCentral.
Managing SQL Snippet Collections using JSON and PowerShell
The post Managing SQL Snippet Collections using JSON and PowerShell appeared first on SQLServerCentral.
Embed Power BI in Jupyter Notebooks
Microsoft recently announced the ability to include Power BI reports inside Jupyter notebooks. After overcoming the dazzle […]
Introduction to generic Power BI themes
Power BI has taken the world by storm when it comes to creating attention-grabbing dashboards that empower […]
SQL Server security – Providing a security model using user-defined ...
When developing an application that accesses SQL Server, you need to set up a security model, so […]
How to choose between SQL and NoSQL databases
Organizations that support data-intensive applications must make many decisions about how to best implement and maintain them. […]
SQL Server Security – Fixed server and database roles
Managing Security for SQL Server is extremely important. As a DBA or security administrator, you need to […]
Customizations in SQL Prompt
The post Customizations in SQL Prompt appeared first on SQLServerCentral.
A data transformation problem in SQL and Scala: Dovetailing declarative ...
Part II : Equivalent Solutions in Functional Programming – Scala Part I of this two-part series presented […]
SQL Templates and Code Snippets in SSMS and SQL Prompt
The post SQL Templates and Code Snippets in SSMS and SQL Prompt appeared first on SQLServerCentral.
Reusing Query Results in SSMS
The post Reusing Query Results in SSMS appeared first on SQLServerCentral.
What is interpolation?
Interpolation is a mathematical technique which was popular before we had a lot of cheap computing power. […]
A data transformation problem in SQL and Scala: Dovetailing declarative ...
Part I: Problem Space, SQL Server Simulation and Analysis This article covers an interesting approach to a […]
SQL Server authentication methods, logins, and database users
Setting up and managing SQL Server security is an important part of building and maintaining your SQL […]
How to become a data scientist: A data-driven approach to ...
Imagine a world without any data. Now imagine the extent of all the available data. Both are […]
Kubeflow for data scientists introduction
Kubeflow is a Machine Learning platform that runs on top of Kubernetes and provides end to end […]
SQL Server interview questions for experienced developers
This article defines ten SQL Server tech interview questions for senior SQL server developers and provides answers […]
DAX financial functions: Depreciation calculations
The series so far: DAX financial functions: Loan calculations DAX financial functions: Depreciation calculations This article continues […]
Sharing SQL Code Snippets with Coworkers, The World and Yourself
The post Sharing SQL Code Snippets with Coworkers, The World and Yourself appeared first on SQLServerCentral.
SQL Server Error Log
Most applications have a log of some sort that tracks activity. SQL Server is no different. It […]
SQL Server Error Log Configuration
Most applications have a log of some sort that tracks activity. SQL Server is no different. It […]
More Gems from the SQL Prompt Treasure Chest
The post More Gems from the SQL Prompt Treasure Chest appeared first on SQLServerCentral.
Deep Learning with GPU Acceleration
Deep Learning is the most sought-after field of machine learning today due to its ability to produce […]
SQL Snippets Galore, Added to SQL Prompt
The post SQL Snippets Galore, Added to SQL Prompt appeared first on SQLServerCentral.
Developing a backup plan
The most important task for a DBA is to be able to recover a database in the […]
Normal Forms
Everyone gives lip service to normalized databases. But the truth is that normalization is a lot more […]
Managing Cross-Database Object References
The post Managing Cross-Database Object References appeared first on SQLServerCentral.
Creating a SQL Code Snippet in SQL Prompt and SSMS
The post Creating a SQL Code Snippet in SQL Prompt and SSMS appeared first on SQLServerCentral.
Questions about SQL Prompt you were too shy to ask
The post Questions about SQL Prompt you were too shy to ask appeared first on SQLServerCentral.
SQL IntelliSense and Autocomplete in SSMS
The post SQL IntelliSense and Autocomplete in SSMS appeared first on SQLServerCentral.
Exploring errors to reveal unauthorized information
Maintaining a secure environment is very hard. There are so many threats that can be exploited that […]
Hidden treasures of SQL Prompt
The post Hidden treasures of SQL Prompt appeared first on SQLServerCentral.
Introduction to DAX Financial Functions – Part 1
In this article, I will introduce the DAX financial functions. These 50-plus functions debuted around the time […]
Azure Data Factory pipelines: Filling in the gaps
Through the term was not really in the vernacular as it is today, I have been a […]
The Social Impact of Artificial Intelligence and Data Privacy Issues
The current era of AI and Big Data is already considered by many as the start of […]
DBA in training: Preparing for interviews
The series so far: DBA in training: So, you want to be a DBA… DBA in training: […]
Heaps in SQL Server: Part 3 Nonclustered Indexes
The series so far: Heaps in SQL Server: Part 1 The Basics Heaps in SQL Server: Part […]
Temporary Tables in SQL Server
Temporary tables are just that. They are used most often to provide workspace for the intermediate results […]
Tracking use of Deprecated SQL Server Features
The post Tracking use of Deprecated SQL Server Features appeared first on SQLServerCentral.
SQL Prompt Snippets to Drop Columns and Tables and Handle ...
The post SQL Prompt Snippets to Drop Columns and Tables and Handle Associated Dependencies appeared first on SQLServerCentral.
Heaps in SQL Server: Part 2 Optimizing Reads
The series so far: Heaps in SQL Server: Part 1 The Basics Heaps in SQL Server: Part […]
Codd’s Twelve Rules
Let me take you back to those thrilling days of yesteryear when the relational model and relational […]
Tracking Underlying Object Changes in Views
Views are used to encapsulate common queries for reuse by SQL Server database objects or applications. They […]