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
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Why End-User Testing Is Even More Important with AI
Comments posted to this topic are about the item Why End-User Testing Is Even...
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers