Phil Factor describes how custom pre- and post-deployment scripts work, when doing state-based database deployments with SQL Compare or SQL Change Automation, and how you might use them to, for example, add a version number to the target database, specify its database settings, or stuff data into some tables.
Until you open the box your data is, like Schrödinger's cat, both safe and breached.
Steve ends his week of career thoughts with a look at the job descriptions that we often use to decide if we want to apply for a job.
Learn how you can script specific objects from SSMS and store or update them in a git repository.
Take advantage of the CI/CD pipeline in Azure DevOps to build, test, and deploy continuously to deliver value to your customers consistently with ease. In this article, Joydip Kanjilal shows you how to get started with Azure DevOps using a .NET Core app.
In the latest version of SQL Prompt, we’ve made improvements to all the most popular features. Our new ranked suggestions algorithm prioritizes the suggestions most relevant to you, tab history improvements let you find old tabs easily and star favorites, and new auto-fixes help you resolve code issues quickly. With support for key features of SQL Server 2019, which was made available this week at Microsoft Ignite, SQL Prompt 10 gives you the latest tools to develop faster, improve code quality, and boost team productivity.
Business Intelligence and Data Science are linked, and complementary. As Steve notes, both can help your organization make better decisions based on data.
Power BI Workbooks | Step by Step - In this tip we look at how to work with Power BI workbooks and in the previous tip we looked at working with Power BI datasets.
If you are evaluating a tool such as a text editor or spreadsheet, it is easy: you just install it, you run it, you decide whether you need it. Job done. However, a similar 'unboxing' or 'unwrapping' of SQL Clone, and installing across a network, is not so quick and easy. Phil Factor's solution is to install and run a complete installation of SQL Clone on a single box. This allows you to try everything out, creating images and deploying clones, while isolated from the network. It can then be extended across a network, subsequently, when it's been fully tested.
Today Steve talks about a new way of achieving some certification and education from Microsoft.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Telp/WA.0821°3111°179 Jl. Dr. Muwardi I No.44, Grogol, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah...
Telp/WA.0821°3111°179 Jl. Kemanggisan Utama Raya No.37, Kemanggisan, Kec. Palmerah, Kota Jakarta Barat, Daerah Khusus...
Telp/WA.0821°3111°179 Blok A, Jl. Puri Indah Raya 20-22, Kembangan Sel., Kec. Kembangan, Kota Jakarta...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers