Call for Speakers in Sunny San Diego
If you're in Southern California, you should come to SQL Saturday #340 and speak at their event. If you want a late summer vacation, submit and come enjoy the event.
2014-08-04
8,341 reads
Articles
Managing Big Data DBAs
Technical support teams usually support familiar hardware and software configurations. Specialization in particular combinations of operating systems and database management software is common, and this allows some team members to gain in-depth experience that is extremely valuable in an enterprise IT setting. How has big data changed this paradigm?
2014-08-04
10,972 reads
How To Write An Interview Winning Resume
Writing a resume that rocks is not an art. Follow these simple guidelines to help secure your next interview.
2014-08-01 (first published: 2012-07-19)
19,783 reads
Create First SSRS Report with SQL Server Analysis Services OLAP Cube
Mubin M. Shaikh outlines how to create SSRS Report on SSAS OLAP Cube. If you don't have much prior knowledge of SSRS, just follow the steps and to have your first report ready on OLAP Cube.
2014-08-01
12,428 reads
Spackle: Making sure you can connect to the DAC
The DAC is an important tool and several things can go wrong when trying to connect to it.
2014-07-31
3,293 reads
A TDD Journey: 1-Trials and Tribulations
Test-Driven Development (TDD) has a misleading name, because the objective is to design and specify that the system you are developing behaves in the ways that the customer expects, and to prove that it does so for the lifetime of the system. Michael Sorens starts an introduction to TDD that is more of a journey in six parts.
2014-07-31
9,842 reads
Data Driven Security
Set a security standard across environments that developers can see and run, but not change.
2014-07-30
3,867 reads
SQL Server Alert for Tempdb Growing Out of Control
One option to get notified when TempDB grows is to create a SQL Alert to fire a SQL Agent Job that will automatically send an email alerting the DBA when the Tempdb reaches a specific file size. This tip explains how to set it up.
2014-07-30
10,602 reads
New SQL Server 2014 Permissions: CONNECT ANY DATABASE
CONNECT ANY DATABASE is one of three new permissions in SQL Server 2014 that can be granted to server logins. What is this new permission good for and why would we ever want this?
2014-07-29
15,047 reads
Avoiding Database Deployment Disasters – 7 Tips
Here are seven practical tips for any 'accidental DBA' or developer, faced with having to deploy an upgrade to a database live to production, in a development environment that is in the early stages of getting the database code “house in order".
2014-07-29
10,764 reads
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
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...
String Similarity II
Comments posted to this topic are about the item String Similarity II
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