Carla Abanes provides a guide on how to create a console application that will generate create scripts for server level objects for multiple SQL Server instances. This is handy in the event of a disaster and you need to create a clone of the SQL Server that is no longer available.
A previous working script show syntax errors on recreating (sp_helptext script line length limitation)
Today we have a guest editorial from Andy Warren that looks at side projects and how you might actually grow our careers.
What's the best way for a SQL programmer to learn about R? It's probably by trying out various experiments with an interesting set of data, and some helpful suggestions that point out the parallels with SQL. Feodor provides the data and the helpful suggestions. The rest is up to you.
A guest editorial from Andy Warren looks at the disagreements between teams in technology.
BI Architect Bill Pearson launches a set of articles surrounding a group of MDX functions specialized to meet the pervasive business need to analyze data within the context of time / date. In this article, we will overview the PeriodsToDate() function, and then we will introduce "shortcut" functions that are based upon it.
In this article, Tim Smith goes through a couple of options to automate heartbeat checks against Azure databases. This is useful if you're moved SQL Server databases to Azure and you want to have periodic checks to make sure the databases are responsive.
In this article, we will show some debugging tips for working with C# and the AMO code for working with Analysis Services and the Data Mining Models.
In this article, we will show some debugging tips for working with C# and the AMO code for working with Analysis Services and the Data Mining Models.
With no end to company hack attacks in sight, will we get new regulation instead?
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...
Whatsapp:08218171955 Jl. Duta Harapan Indah Jl. Kapuk Muara Raya No.33 Blok K.32, Kapuk Muara,...
Jl. Duta Harapan Indah Jl. Kapuk Muara Raya No.33 Blok K.32, Kapuk Muara, Kecamatan...
Jl. Prof. Drg Jl. Prof. drg. Soeria Soemantri No.33, Sukawarna, Sukajadi, Bandung City, West...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers