Create, Populate, and Subset a Pandas Dataframe from a CSV File
In this article we demonstrate how to transfer data via a CSV file from a SQL Server database to a Pandas dataframe and then subset the dataframe in Python.
2021-09-03
cross platform
SQL Window Functions in SQL Server, Oracle and PostgreSQL
In this article we look at using Window Functions in SQL Server, Oracle and PostgreSQL to see the differences and similarities of the syntax.
2021-04-19
A Unified Approach to Multi-DataBase Query Templates
While trying to get the information he needed out of various SQL, MySQL and Oracle environments, Michael finally got tired of endlessly flicking through reference manuals and having to work so hard just to formulate his queries. So he decided to build a cross-platform Query Template solution to make his life easier, and he even went as far as building a .NET control to be integrated into applications. He's been kind enough to share the control, and the theory behind it, with us.
2009-10-28
1,971 reads
Blogs
Removing a Deleted Column from a Data Masker Masking Set
By Steve Jones
Data Masker for SQL Server is a great tool ensuring the data you use...
Containers: A Short Rant
I find myself doing more and more work with containers. Yet, I also find...
Daily Coping 20 Sep 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Metadata-Data-Ratio in a table
Hi all, My understanding about the structure of data within SQL Server is that...
Always On - why No failover occurred?
Hi, I am using SQL 2016 (13.0.5888.11). Last Saturday (18th September), in non-office hours,...
Log Shipping Truncate Log File
Good Morning, I have read that taking a log backup truncates the log file....
Ask SSC