The way that various departments might view a team of technology employees can affect how we interact. Andy Warren remembers a few situations and notes it's always more fun to join a team with a good reputation.  Read more...

Preparing for your first (or next) interview or job in SQL Server. A good introduction from Craig Farrell.  Read more...

Relational division is used in SQL to select rows that conform to a number of different criteria. Dwain Camps explains how to use it, and shows the performance gains.   Read more...

This metric monitors whether a server principal’s default database is offline. When you create a SQL Server server principal (formerly referred to as a server login) it has a default database setting that is used to assist in a connection request when no database is specified.  Read more...

Today Steve Jones notes that the explosion of cheap hardware and electronics might be good for data professionals.  Read more...

Part 3 of the AO and FCI integration series. This article gets SQL Server configured on the nodes and ready for work.  Read more...

A SQL Server MSDB database is flagged as "suspect"... what can you do? John Grover has some suggestions  Read more...

Distributed File Databases manage large amounts of unstructured or semi-structured data. Buck Woody shows how to install Hadoop in your Data Science lab to experiment with an example of the breed.  Read more...

Naming conventions are always tricky.  Read more...

There are times when retrieving data for complex business requirement requires you to temporarily store one or more results sets for a short period of time. Typically these temporary tables are stored in the scope of the current connection, but they may also need to be available across multiple connections.   Read more...

The DBA Team are back, ready to save another DBA. In this episode, a rogue DBA sabotages the backups, can Robyn Page, Steve Jones, Grant Fritchey, and Phil Factor find the solution? Save the backups...save the business.   Read more...

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...

Intersect with your favorite Microsoft experts in Orlando, Florida April 13-16, 2014 at this year’s most exciting tech conference: DEVintersection.com. Register with the discount code "RedSimple" for $50 off your registration.  Read more...

Today is the first day of general availability for SQL Server 2014.  Read more...

With the release of SQL Server 2014, the licensing options have changed slightly. Read on to discover how you might choose to change your licensing in the future.  Read more...

SQL Server 2014 is being released and a change in the defaults will ensure that more instances will run smoother.  Read more...

A new enhancement in SQL Server 2014 allows you to directly enter C# code in your stored procedures.  Read more...

Today Steve Jones notes that an advance in technology will help change the way he works.  Read more...

In the world of data it’s always been about speed. SSD’s have become very common on consumer machines and not unusual in corporate datacenters.   Read more...

Steve Jones talks about the women in technology, and other efforts to help minorities.  Read more...