The first thing you need to understand about SQL Server is indexes, but somehow many of the basic questions don't often get asked or answered much on forums. Rob Sheldon answers some of these questions about SQL Server Indexes and indexing.
SQL Saturday is coming to Huntington Beach, CA on April 26 2014. This is a free day of training and networking for SQL Server Professionals - there are also 2 paid-for precons on April 25 presented by Jason Horner and Bradley Bell. Register for SQL Saturday Orange County while space is available.
Disk performance can make a difference to your SQL Server instance. Steve Jones discusses a few things this week.
Load tests give the database administrator quite a lot of valuable information and may make the difference between poor and acceptable application performance. But are there any gotchas or traps associated with big data?
Preparing for your first (or next) interview or job in SQL Server. A good introduction from Craig Farrell.
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.
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.
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.
Today Steve Jones notes that the explosion of cheap hardware and electronics might be good for data professionals.
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.
It is Friday, the queries are running, and nobody is watching the bill. That...
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Wa:0817781222 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
Wa:0817781222 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
Wa:0817781222 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
When running bcp on Linux, what is the field terminator?
See possible answers