Emergency Preparedness
Being prepared for things to go wrong is important, more so these days than in much of our past.
Transfer data from SQL Server to MySQL
In this article we look at how to use PowerShell to transfer data from SQL Server to MySQL.
Can You Catch SQL Injection?
Steve found an attack against Google's SQL database that their SREs detected.
Installing PostgreSQL 11 on Windows with Step-by-step Instructions
PostgreSQL is a free database management system (DBMS). PostgreSQL 11 is the new version of this DBMS. We will take a look at how to install PostgreSQL 11 on Windows. This article covers where to download PostgreSQL 11, how the installation process looks like, and how to connect to the PostgreSQL server. Step-by-Step Installation on Windows […]
How do You Identify Object Dependencies in SQL Server
In this article we look at different ways to determine if one SQL Server database object is dependent on another database object.
Using Filters to Fine-tune Redgate Database Deployments
Filters are used by Redgate's SQL Compare, SQL Source Control, DLM Dashboard, and SQL Change Automation. A typical use for a filter is to work on just one schema within a database or just a limited set of tables and routines. You would also want to use a filter to exclude certain object, such as database users, from comparisons. Phil Factor explains how they work, and how to create, edit and then use them within the various Redgate tools.
The Evolution of Windows
Today Steve looks back at Windows, and how Windows 10 might be the last version. Perhaps this is the model we'll see with SQL Server in the future.
Using Recommendations for MAXDOP and Max Memory During Installation
Finally, two important SQL Server recommended settings have been introduced during the installation process. These are the settings that every DBA (should) change after every single installation. The settings are MaxDOP and Max Memory. This article looks at each of these settings and how they are presented during installation. MaxDOP When an instance of SQL […]
Blogs
Prepping for Certification, Part 1 of ?
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
How to Avoid Knowledge Stagnation
You want the short answer? Well, the only antidote to knowledge stagnation is probably...
Demystifying Fabric Workspaces: The Nerve Center of Your Data Universe
By Chris Yates
It always starts the same way. You open your laptop on a Monday morning,...
Forums
Guidelines and Requirements
Comments posted to this topic are about the item Guidelines and Requirements
Copying Production Schema
Comments posted to this topic are about the item Copying Production Schema
Workspace Identity Authentication for your Power BI Semantic Models in Microsoft Fabric
Comments posted to this topic are about the item Workspace Identity Authentication for your...
Question of the Day
Copying Production Schema
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers