Introduction Recently, I had the task of analyzing a varchar field for special characters. The field contained text entered by the user with a standard US keyboard; however, the proprietary software was breaking up the text and delimiting it with characters whose ASCII values were above 127. Eyeballing the text that I dumped using a […]
Availability Groups are a good way to use High Availability in SQL Server, Today Steve wonders if you have any improvements you would make to the technology.
In this article we look at how to upload and download files from Azure Storage using SQL Server Integration Services.
SQL Compare and SQL Data Compare can be used together, from the command line, to provide a complete build process, or to script out changes to both the database and its development data. For doing this routinely, I find it easiest to script the operation using PowerShell.
Microsoft fights back against hackers after a recent vulnerability in a management framework.
Learn how to create dynamic data slicers in Power BI with this step by step example to show how this can be done.
Phil Factor takes a staged approach to generating development data, creating one project that simply copies data from an existing database, another that copies most data but generates any personal or sensitive data, and a third that starts from 'anonymized' data and then generates other columns entirely and increase the number of rows for testing.
Now that we've explored, in preceding levels, some of the information that is available about indexes, triggers, keys and distribution statistics, we can concentrate on the tables themselves and their columns.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Medan Mall, Kompleks No.10, Pusat Ps., Kec. Medan Kota, Kota Medan, Sumatera Utara 20212
Jl. KL. Yos Sudarso No.223 J, Pulo Brayan Kota, Kec. Medan Bar., Kota Medan,...
Whatsapp:08216977726 Jl. Trans Sulawesi, Keurea, Kec. Bahodopi, Kabupaten Morowali, Sulawesi Tengah 94974
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers