SQL Saturday #198 - Vancouver
SQL Saturday comes back to Vancouver, BC on Feb 16, 2013. Come join in if you can.
Hunting Developers
Steve Jones is up in the Redmond area at Microsoft's HQ looking for SQL Server developers. This editorial was originally published on April 17, 2008. It is being re-published as Steve is on holiday.
Windows Server 2012 Deduplication – Should you use it with SQL Server Backups?
Windows Server 2012 introduces native deduplication functionality. While this is a promising new Windows feature for other file types and characteristics, there are some potential pitfalls that you need to be aware of when it comes to deduplication specifically for SQL Server backup files.
Interviewing Tips for a Database Position
Interviewing for a database position is a careful game of give and take. Knowing what to expect and how to prepare for your interview is important, but it's only half the battle. You'll also need to ask questions to see if the job, and the company, is a good fit for you.
Mastering the Art of Conversation and Making Business Contacts
In NYC on Feb 21 at 6:30, Don Gabor has a short seminar to help with your networking. Whether you are chatting in small groups or one-on-one at a networking event, IT conference or after-hours party, your ability to master the art of conversation will help you find and connect with business contacts.
A Computer Goes to College
IBM is sending a Watson supercomputer to college. We don't know what will happen with this experiment, but it is exciting for those of us looking forward to interacting more with computers in the future.
Exploring the Varbinary Type
A brief look at the Varbinary data type and its uses in SQL Server for beginners.
Evaluating Policies on Multiple SQL Server Instances using Central Management Server
you have created a SQL Server Policy to check database recovery models. Now you need to check the databases on all of your SQL Server instances. In this tip we will show how you can evaluate a SQL Server policy against multiple instances.
Data Journalism
Data Journalism is a new idea that is bringing us a new way of reporting on the world. Steve Jones thinks this might be useful inside of all kinds of organizations.
Precision Indexing: Basics of Selective XML Indexes in SQL Server 2012
Seldom has a SQL Server Service pack had such an effect on database development as when SQL Server 2012 SP1 introduced selective XML indexes. These transform the practicality of querying large amounts of XML data. Seth Delconte demonstrates how and why this feature makes all the difference.
Blogs
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
Forums
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Spring Connections and Learning at PASS On Tour
Comments posted to this topic are about the item Spring Connections and Learning at...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers