New SQLonCall Show Posted! Check it out – Chris has put together How to hire a DBA as a show! Tips, tricks – and much more. Find out what you need to know from both the hiring and the being-hired end of things. Watch the show here. > …and, you can catch the most recent SelectViews SQL Server Show here […]

Don’t Miss the Latest SQLonCall: Basic Security Best Practices (new show posts tomorrow!) SelectViews: Software as a Service, Data Archive Challenge and more Featured Article(s) Diagnosing Poor Data Access Code Using SQL Profiler I created this article to assist DBAs and application developers who need to optimize data access code in their applications. This document covers a few cases where […]

Featured Article(s) SQL Server server and Databases Health check process The following stored procedure is really a collection of several TSQL system procedures designed to monitor server and databases configuration values and keep the DBA Informed about databases health Want to manage multiple implementations of the same database? Want to build stored procedures in seconds? Auto generate SQL Delete, Update […]

I Need Your Help! Please – if you have a minute or two – we have a new concept we’d like to first explain to you, then get your feedback on. I need to know what you think of it, what you’d like to see, what type of experiences you’ve had, etc. I’ve created a short video explaining the idea, […]

Watch the Latest: SQLonCall: Security and SQL Server – Best Practices SelectViews: Software + Service, Book Look and More Featured Article(s) Who do you Hire: The Decision You Need to Make I was talking to a director that I know and he mentioned to me that he has a scale that he measures prospective employees on. If you evaluate these […]

New SQLonCall Show Live Now Basic Security Practices – Learn about mistakes commonly made when working with security and SQL Server. Lost consumer data, encryption, hacker attacks and much more – find out where to start looking and what to consider. > Watch The Show Here Featured Article(s) Troubleshooting SQL Server 2005 Snapshot Replication In this article, Alexander Chigrik explains […]

Watch the Latest SQLonCall All about your first month on the job – things to think about, things to consider, key points to address. A great show with lots of positive feedback! An all-new show will post tomorrow – catch the current show today! > Watch Here Featured Article(s) SQLCMD — Part III (Vadivel Mohanakrishnan) This is the last part […]

Have You Watched The SQL Server Show Yet? SelectViews posted on Friday – here are the show notes; Software as a Service Issues, SQL Server Data Archive Challenge, Linking Access Tables to SQL Server. Also, BookLooks – Apress TSQL Recipes, the 60-Second SQL Server Tip of the Day and Much More. (Don’t forget the SQL Server Challenge – we’re looking […]

New Weekly SQL Server Show, SelectViews, Posted This week’s show explores Software as a Service Issues, SQL Server Data Archive Challenge, Linking Access Tables to SQL Server. Also, BookLooks – Apress TSQL Recipes, the 60-Second SQL Server Tip of the Day and Much More. > Watch the Show Here Pulling Information From Non-Relational Sources… …is possible. In fact, pulling together […]

Last Day To Catch the Current SelectViews SQL Server Show …before tomorrow’s show posts. Watch it here. (Don’t forget, you can win $200 – congrats to our latest winner, Donna M.!) Webcast Today Moving from SQL Server 2000 to SQL Server 2005 Security We’ll look into the differences between the approaches to security, how they apply to your database, the […]