Fernando G. Guerrero

Fernando G.

Fernando G. Guerrero is a SQL Server lecturer and developer and a principal technologist for QA, UK. He is an MCDBA, an MCSD, an MCSE+Internet, and a SQL Server MVP and MCT. He is coauthor of Microsoft SQL Server 2000 Programming by Example (Que).

UDFs Provide a New IDENTITY
Use UDFs in SQL Server 2000 to create new IDENTITY functionality.
Using Fake Temporary Tables 4
You can use data sets inside triggers and in stored procedure calls by creating permanent tables that emulate temporary tables.
Fake Temporary Tables and SQL Server 2000 1
SQL Server introduces several new features that might have implications for whether and how you use fake temporary tables with this new release.
A/C Circuits and T-SQL
Here's a practical application of using a user-defined function (UDF) to manipulate complex numbers.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups 1

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular execution of T-Log backups on Full (and Bulk-Logged) Recovery databases helps keep thing “fit and trim”. Most of the time, setting up a Notification for when T-Log Backup Jobs fail is enough to let you know when something goes wrong....More
Sep 1, 2015

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks 3

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')         DROP TABLE TableToDrop; GO Neither is this: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TableToDrop')         DROP TABLE TableToDrop; GO Yet, I see both of those used all of the time – over and over again. Even though it’s 2015.  ...More
Aug 27, 2015

A Replacement for Maintenance Plan Backups 1

This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part series on AlwaysOn Availability Groups and SQL Server Agent Jobs. But, I also figured that this is enough of an important topic to merit its own blog post....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×