Power BI for Business Intelligence
The post Power BI for Business Intelligence appeared first on SQLServerCentral.
Execution Plans Don’t Have the Yellow Bang They Really Need.
When SQL Server is purely making an estimate up out of thin air, with no freakin’ idea what the real answer is, it doesn’t give you any kind of warning. It just produces an estimate that looks scientifically accurate – until you …
Finding the Optimal Value of Hyperparameters through Grid Search
Summary This article aims at demystifying what grid search is and how we can use to obtain optimal values of our model parameters. It would be highly beneficial for the reader if the prequels to this article are read to gain a holistic understanding of …
DIY Database Clones
Database DevOps techniques require an easy way to provision many copies of a database, even a large database, for development work and especially for testing work. Ideally, these databases should be disposable and easy to create; developers should be a …
How do you monitor your databases? Take the survey!
The post How do you monitor your databases? Take the survey! appeared first on SQLServerCentral.
Detecting Database Drift during Flyway Database Development
The post Detecting Database Drift during Flyway Database Development appeared first on SQLServerCentral.
Five Facts about the SQL Server Resource Database
The post Five Facts about the SQL Server Resource Database appeared first on SQLServerCentral.
Announcing Fundamentals Week: May 10-14, $295
You love learning from me. You’ve attended some of my free online streams, read my blog posts, and you use the First Responder Kit. You enjoy my laid-back, humorous approach to sharing what I’ve learned over the years. You love live classes …
Identify Profiles Actually In-use to Make Database Mail Migration Efficient
Introduction According to Microsoft, Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine. Using Database Mail, your database applications can send e-mail messages to users. The messages can contain qu …
How to improve DevOps communication clarity
The post How to improve DevOps communication clarity appeared first on SQLServerCentral.
SQL Server security – Providing a security model using user-defined roles
When developing an application that accesses SQL Server, you need to set up a security model, so each user gets the access they need based on their job duties. Some applications require the same access for all users, while other application might requi …
Reducing the Frequency of SQL Server Central Newsletters
We are reducing the frequency of SQL Server Central newsletters from 5 a week to 3 starting on May 3. We will send out our regular newsletter on Monday, Wednesday, and Friday to all subscribers. The Database Weekly newsletter will continue to come out …
SQL Server plan cache mining – Plan attributes
The execution plan cache in SQL Server is a treasure trove of information about queries that have recently executed. In addition to query text and execution plan details, a wide variety of statistics, options, and parameters are available to research, …
Creating Database Build Artifacts when Running Flyway Migrations
The post Creating Database Build Artifacts when Running Flyway Migrations appeared first on SQLServerCentral.
An Introduction to Azure Data Explorer
Introduction Big data consists of very large datasets, which can be structured, unstructured, and semi-structured. Data may be coming from various data sources in real-time or in batches. The traditional tools and technologies we have used in the past …