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 Server provides the GROUP BY clause as a means to take a set of detailed values […]
The VALUES clause is probably one of the most misused features in SQL. If you look at […]
The post SQL Prompt ALT S Magic appeared first on SQLServerCentral.
The post Exploring Auto-fix in SQL Code Analysis appeared first on SQLServerCentral.
If you look at the postings on SQL forums, you will notice that people are sloppy. They […]
The post Managing, Editing and Comparing SQL Code Analysis Settings appeared first on SQLServerCentral.
The post How to Compare Two SQL Prompt Styles appeared first on SQLServerCentral.
The post Creating and Maintaining a SQL Code Snippet Library appeared first on SQLServerCentral.
The post Managing SQL Snippet Collections using JSON and PowerShell appeared first on SQLServerCentral.
Microsoft recently announced the ability to include Power BI reports inside Jupyter notebooks. After overcoming the dazzle […]
Power BI has taken the world by storm when it comes to creating attention-grabbing dashboards that empower […]
When developing an application that accesses SQL Server, you need to set up a security model, so […]
Organizations that support data-intensive applications must make many decisions about how to best implement and maintain them. […]
Managing Security for SQL Server is extremely important. As a DBA or security administrator, you need to […]
The post Customizations in SQL Prompt appeared first on SQLServerCentral.
Part II : Equivalent Solutions in Functional Programming – Scala Part I of this two-part series presented […]
The post SQL Templates and Code Snippets in SSMS and SQL Prompt appeared first on SQLServerCentral.
The post Reusing Query Results in SSMS appeared first on SQLServerCentral.
Interpolation is a mathematical technique which was popular before we had a lot of cheap computing power. […]
Part I: Problem Space, SQL Server Simulation and Analysis This article covers an interesting approach to a […]
Setting up and managing SQL Server security is an important part of building and maintaining your SQL […]
Imagine a world without any data. Now imagine the extent of all the available data. Both are […]
Kubeflow is a Machine Learning platform that runs on top of Kubernetes and provides end to end […]
This article defines ten SQL Server tech interview questions for senior SQL server developers and provides answers […]
The series so far: DAX financial functions: Loan calculations DAX financial functions: Depreciation calculations This article continues […]
The post Sharing SQL Code Snippets with Coworkers, The World and Yourself appeared first on SQLServerCentral.
Most applications have a log of some sort that tracks activity. SQL Server is no different. It […]
Most applications have a log of some sort that tracks activity. SQL Server is no different. It […]
The post More Gems from the SQL Prompt Treasure Chest appeared first on SQLServerCentral.
Deep Learning is the most sought-after field of machine learning today due to its ability to produce […]
The post SQL Snippets Galore, Added to SQL Prompt appeared first on SQLServerCentral.
The most important task for a DBA is to be able to recover a database in the […]
Everyone gives lip service to normalized databases. But the truth is that normalization is a lot more […]
The post Managing Cross-Database Object References appeared first on SQLServerCentral.
The post Creating a SQL Code Snippet in SQL Prompt and SSMS appeared first on SQLServerCentral.
The post Questions about SQL Prompt you were too shy to ask appeared first on SQLServerCentral.
The post SQL IntelliSense and Autocomplete in SSMS appeared first on SQLServerCentral.
Maintaining a secure environment is very hard. There are so many threats that can be exploited that […]
The post Hidden treasures of SQL Prompt appeared first on SQLServerCentral.
In this article, I will introduce the DAX financial functions. These 50-plus functions debuted around the time […]
Through the term was not really in the vernacular as it is today, I have been a […]
The current era of AI and Big Data is already considered by many as the start of […]
The series so far: DBA in training: So, you want to be a DBA… DBA in training: […]
The series so far: Heaps in SQL Server: Part 1 The Basics Heaps in SQL Server: Part […]