Multiplatform ODBC support for SQLServer
The Microsoft SQL Server Connectivity team has a survey on the need for ODBC support for other platforms. If you use SQL Server from other platforms, let them know.
Querying Oracle from Powershell Part 1
In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can...
Querying Oracle from Powershell Part 2
In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...
Using The Data Mining Query Task in SSIS
The Data Mining Query Task can be used to run prediction queries based on data mining models built in analysis service.
A SQL Evening in London
Spend an evening with Itzik Ben-Gan, Greg Low, Davide Mauri and Bill Vaughn in London on March 16th. Come attend if you can.
Fixing DBCC CHECKDB Msg 8992 Errors
Returning author Wayne Sheffield recently had some database corruption - read about how it was fixed.
Usage Based Pricing
Software pricing is a controversial topic, but Steve Jones found an article saying many enterprises would prefer usage based pricing. Do you think it's better?
Efficiently Reuse Gaps in an Identity Column
This article will demonstrate an efficient way to reuse gaps in an identity column. Please note that this is something you normally shouldn't be bothered about in a well-designed database or application. However, there are circumstances where you are forced to do this.
How Do You Drive Your DBA Mad?
I’ve written about a few ‘worst practices’ over the years to call attention to some things that are bad (or...
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
ActualExecute
IT's OK I've create a stored procedure ActualExecute which is the TSQL script equivalet...
BCA Finance Seasons City Layanan Mobil. Tlp/wa:085373737845
Seasons City Mall, Jalan Prof. Dr. Latumenten V No.33 Lt LG, RT.13/RW.1, Jemb. Besi,...
BCA KCP Pasar Minggu Center Call Cs: (+62 821°3111°179
Jl. Lenteng Agung Raya No.26 E-F, Ps. Minggu, Kota Jakarta Selatan, Daerah Khusus Ibukota...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers