Small Changes and Big Impacts
Using new features and changing code can cause problems in your environment. Always test to be sure that the impact is acceptable.
SQL Server 2016 Availability Group - Automatic Seeding with SSMS 17.x
In SQL Server 2016 the availability group automatic seeding functionality is implemented. This article will detail the steps to use of SSMS with automatic seeding and its limitations.
How to Send a TDE Encrypted Backup to Someone Outside Your Organization
Once you enable your database to be encrypted with Transparent Data Encryption (TDE), the physical database files, and the database backups are encrypted. If your database and database backup are encrypted, then how can you send the encrypted backup to a person outside your organization?
So Many Choices with SQL Server
There was a day when you didn’t have many decisions to make about a new SQL Server instance. You had to choose from a few editions and two licensing models: per proc or server cal. It wasn’t long ago that SQL Server would almost always be installed on a physical server on premises, and the […]
SQL Server 2017 for Linux First Impressions
Microsoft has released a version of SQL Server 2017 for Linux.
READ COMMITTED SNAPSHOT ISOLATION and High version_ghost_record_count
Developer shops may decide to use Read Committed Snapshot Isolation (RCSI) to reduce contention, and possibly improve performance, but it is not without its own pitfalls. In this article, Uwe Ricken describes a situation where long running transactions caused a severe performance degradation when RCSI was in use.
Ad Hoc Logs
We often make changes to production systems in an ad hoc manner. Steve asks how much auditing we might have in place.
Getting query text from SSMS into a CSV with PowerShell
You have times where you need to copy/paste something out of SSMS' grid view results pane that has a carriage return in it. Trying to copy/paste that data into Excel can be a headache and cause you to waste precious time reformatting. This just offers a tidbit of PowerShell code to help.
Scripting the Description of Database Tables Using Extended Properties
Stored procedures, for example, are very easy to document. The comment block at the beginning stays with the code and a CREATE or ALTER script contains everything to reproduce the proc. SQL Server tables, however, are more difficult to document. You can use Extended Properties to document columns and constraints, but working with Extended Properties is difficult at best. Phil Factor demonstrates ways to easily add Extended Properties to your build scripts.
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Alamat BCA KCP BSD Sektor I Telp:0821°8200°233
Telp/Wa 628218200233 Komp, BSD City, Ruko Barcelona, Blk. E9 No.30 RK No. 28, 29,...
Alamat BCA KCP Cikupa Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Raya Pemda Blok R-1 No.07, dan No.08, Bojong, Kec. Cikupa, Kabupaten...
Alamat BCA KCP Borobudur Telp:0821°7555°651
Telp/Wa 628217555651 Jl. Borobudur Raya Blok M No. 36-37, Bencongan Indah, Kecamatan Kelapa Dua,...
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers