Python for the SQL Server DBA

  • Article

Python is increasingly used by DBAs as a general-purpose scripting language, despite the pressure to adopt Microsoft's PowerShell. They find it easy to learn, powerful, and reasonably intuitive. Here Timothy Wiseman, a working DBA, explains the attraction of Python and gives a general introduction to the language, suitable for anyone who has been wondering whether to give it a try.


5,678 reads

Accessing SQL Server Databases with PHP

  • Article

This paper discusses how to use several of these features by closely examining parts of the Example Application in the SQL Server 2005 Driver for PHP product documentation in MSDN. This paper assumes that the reader is familiar with programming in PHP, that the reader has a computer that meets the System Requirements listed for using the driver, and that the AdventureWorks example database is installed from CodePlex.


4,942 reads

Accessing Data from a Mobile Application

  • Article

Data access is an important aspect of developing applications with the Microsoft® .NET Compact Framework for Windows Mobile® devices. By using the existing architecture to send and receive data between your mobile application and your application server, you can pass data with either DataSets, custom objects, or scalar values.


3,781 reads


Nerd Journey Podcast with Nick Korte


I’m thrilled to have recently recorded a podcast with Nick Korte from Nerd Journey....

Daily Coping 18 May 2021


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Creating a configurable SSMS script


Several times over the last few weeks I’ve gotten a request to create a...

Read the latest Blogs


SELECT DISTINCT but only on two columns...

By stephen.aa

Hello: I have the following query... SELECT JobOperations.jmoJobID AS JobNo, JobAssemblies.jmaPartID AS PartID, JobAssemblies.jmaPartShortDescription...

How to execute multiple 'INSERT INTO' statements without crashing SSMS?

By seleneplatt

I need to execute multiple 'INSERT INTO' statements to replicate records in a table...

SQL Server on Linux over Docker connecting through MS ODBC

By N_Muller

I'm trying to connect SQL Server installed on a Linux server through Docker from...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers