Various Authors

Various
Authors
Articles
SQL Server Magazine UPDATE, December 14, 2006--Swivel Puts a New Twist on BI for the Masses
Is Swivel just another way to fritter away time on the Internet or is it really the way that BI will become available to the masses? Also, check out the new SQL Server Best Practices Web site, ring in on this month's Reader Challenge, and more!
SQL Server Magazine UPDATE, December 7, 2006--Specializations for Microsoft Partners
Do you know what you want to be when you grow up? Browsing the list of the new specializations for Microsoft Partners might spark your imagination. Plus, see who was named IT Pro of the Month, check out a better logging tool for DTS, and more!
SQL Server Magazine UPDATE, November 30, 2006
Learn about Microsoft's dramatic improvements in SQL Server security, check out the launch of Windows Vista and the 2007 Office system, use the RECOMPILE query hint to solve parameter sniffing problems, and more!
SQL Server Magazine UPDATE, November 16, 2006--What's New for You in SP2?
Last week, Microsoft announced the SQL Server 2005 SP2 CTP. Check out the preview and learn about the new SQL Server enhancements coming your way. Plus, learn about Microsoft's other important product milestones, take the Reader Challenge, and more!
SQL Server Magazine UPDATE, November 9, 2006--Follow the Money
If a rising tide floats all ships, database professionals on the good ship SQL Server should see their own fortunes rising on the strength of Microsoft’s database platform. Plus, check out the Database Publishing Wizard and more!
SQL Server Magazine UPDATE, November 2, 2006--Great Minds Think Alike
Follow Brian Moran as he traces the footsteps of two illustrious SQL Server gurus, check out the debut of Kevin Kline's new Tool Time forum and column, make the most of ASP.NET login controls, and more!
SQL Server Magazine UPDATE, October 26, 2006--Share a DBA, Reduce Your Risk 1
Businesses are increasingly exposed to risk because they lack the readiness to handle core data-management problems. See how a shared DBA model could help. Plus, get the answer to the Catch That Bug puzzle and more!
SQL Server Magazine UPDATE, October 19, 2006--TPC’s New Benchmark Strives for Realism
The TPC’s new specification, TPC-E, strives for a more real-world simulation. Plus, check out the latest Catch That Bug! T-SQL puzzle by Itzik Ben-Gan, find out the top 10 things you'll learn at TechX World, and more!
SQL Server Magazine UPDATE, October 12, 2006--Application Server or Database Server?
When is a database not a database? And where does SQL Server the database start and SQL Server the application server end? Explore these questions, learn to handle interoperability with humor, read FAQs about SQL Server Everywhere, and more!
Special Edition of Developer Update--Using Technology for Evil--September 15, 2006
Although developed with good intentions, AJAX and CAPTCHA can be used for evil.
Special Edition of Developer Update--The Importance of Testing--August 22, 2006
Concentrating on testing is one of the most challenging tasks for developers. I've lost count of the number of times a developer has raced into my office to tell me that a piece of software is done, only to race back out of my office when I ask, "Have you tested it?"
SQL Server Magazine UPDATE, October 5, 2006--SQLCLR: The Barbarian at the Gate
Does the SQLCLR give devious barbarian developers a way to overrun our relational database strongholds? We don’t know yet--learn why. PLUS: Solve your database interoperability problems with strategies you learn at two upcoming events!
Developer Update--.NET Now Positioned to Replace COM--September 1, 2006
In this issue of Developer Update, read about the changing mind-set concerning .NET's impact on COM and readers' experiences with merging changes in Team Foundation Server (TFS).
SQL Server Magazine UPDATE, September 21, 2006--Eliminating Stored Procedures? Look Before You Leap
How do you know what best practices are right for you? Learn how savvy SQL Server professionals avoid absolutes. Also, plan for disaster recovery with SQL Server 2005 high-availability, and more!
SQL Server Magazine UPDATE, September 14, 2006--Be a BI Expert--or Just Look Like One
A recent IDC report hails the start of a new wave of BI expansion. Reading the report give you what you’ll need to know as a database professional. ALSO: Send your solution to this week’s new T-SQL puzzle by Itzik Ben-Gan!

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
Dec 16, 2014
Sponsored

Eight SQL Server Signs the Illuminati Exist

Make no mistake about it, the signs that the Illuminati exist are all around us. You can find their markings on our buildings, on our currency and even in our music videos. That’s right, they’re everywhere!...More
Dec 2, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 16: Job Synchronization Checkup Logic

With Linked Servers configured to allow cross-host or cross-box communication between the servers you’re using to host your AlwaysOn Availability Groups, it’s time to start looking at some scripts that can be used to regularly check whether or not SQL Server Agent jobs are correctly synchronized across all servers in your topology....More
Abstract illustration of linked SQL Servers
Nov 18, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 15: Setting Up Linked Servers

Learn about setting up Linked Server definitions to let two (or more) servers in an AlwaysOn Availability Group talk to each other and check up on job statuses of jobs running on each other....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) ×