Instead of using a custom SSIS-based project to upload content from an on-premise SQL Server database to Azure PaaS-based SQL Database, Marcin Policht presents an alternative approach. Using the bcp utility not only eliminates the need for any custom development, but also rivals SSIS in terms of its data transfer efficiency.
Part 2 of a series on how to automate partition management. In this article learn how easy managing and maintaining a sliding window partition scheme can be with PowerShell.
What do you do as a DBA if you get asked to cook the books? With the economy doing poorly, some executives will be tempted to mis-report earnings and they might ask the technical people to help. Steve Jones has a few thoughts.
One of the core components of the Hadoop framework and responsible for the storage aspect is HDFS. Unlike the usual storage available on our computers, HDFS is a Distributed File System and parts of a single large file can be stored on different nodes across the cluster. Here are some of the key concepts related to HDFS.
SQL Saturday #292 in Detroit, MI, is looking for speakers. The event is May 17, 2014, and there are still some speaking slots available.
The #sqlhelp hashtag on Twitter is a great way to interact with the SQL Server community and get help.
SQL Server Integration Services does not provide native SFTP, encryption or archiving task components. This article presents a set of open source custom task components that provides these functions.
There are many useful command-line applications that are either associated with, or are distributed with, SQL Server. They all have their uses and several become important as part of script-based automation of tasks. It is definitely worth knowing what is lurking in your tools\binn directory.
SQL Saturday is coming to Madison on March 29, 2014. This is a free training event for SQL Server professionals and those wanting to learn about SQL Server. Steve Jones and many others will be presenting, so make sure you register early to secure your place.
SQL Server is so large and complex that it's like an operating system. In fact, there the core engine is often referred to as the "SQL OS" by Microsoft developers. Steve Jones would like to see SQL Server as it's own OS at some point.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Tlp/WA.(+62 821°3111°179 Jl. Kebon Bawang VII No.40 2, RT.2/RW.6, Kb. Bawang, Kec. Tj. Priok,...
Tlp/WA.(+62 821°3111°179 Jl. Cempaka Putih Raya No.118 B,C,D, Cemp. Putih Tim., Kec. Cemp. Putih,...
Tlp/WA.(+62 821°3111°179 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers