XP_ENUM Stored Procedures

Digging a little deeper this week into extended stored procedures, we find the xp_enum procedures. These
procedures require no parameters but provide a handy bridge to the operating system and is extremely helpful for developers.

SQL Server CE: New Version Lets You Store and Upda

Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS.

Blogs

Restoring Backups from Azure Blob with dbatools

By

Recently I needed to write a PowerShell script that could build a backup set...

Good to see you at Houston Tech Fest 2019!

By

It was awesome to see a great crowd at the triumphant return of Houston...

Using kubectl logs to read the SQL Server Error Log in Kubernetes

By

When working with SQL Server running containers the Error Log is written to standard...

Read the latest Blogs

Forums

SQL Server Restore precheck gets free space wrong

By BobAtDBS

I'm trying to move a large database (22 TB) from a stand alone server...

2nd Server min requirements for transaction log shipping & reducing license cost

By guht

I will have a 64-bit 2008 R2 SQL Server Standard edition acting as the...

how to hide the passsword in the log file when the package fails.

By mcfarlandparkway

I have an encryption and decryption package and the keyId public and private from...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers