Every so often I see a post in a forum or on Twitter about the use of xp_cmdshell. Usually it is someone looking for...  Read more...

Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...  Read more...

Modeling and programming a neural Network in SQL Server from new author Silvia Cobialca. Learn how you might be able to implement this AI construct in SQL Server to make predictions.  Read more...

Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...  Read more...

Most of you are aware that the Microsoft SQL Server 2000 Desktop Engine (MSDE) limits database size to 2 gigabytes. ...  Read more...

I'm reading SQL Server MVP John Magnabosco's new e-book, Protecting SQL Server Data, and he includes a database schema to...  Read more...

So you’ve got some packages that regularly extract data to one or more text files, but you know that from...  Read more...

This script export data into excel/CSV file using BCP comnand with column headers  Read more...

I was in a presentation last week where the presenter was talking about the ANSI/ISO SQL standards. For the most part the...  Read more...

  Your servers are only as fast as the slowest part, hard drives. To feed other parts of the system we have...  Read more...

In the next week or so I’ll be upgrading the SQL 2005 server that has the SQLSaturday database and I’m...  Read more...

This past Friday I received a call from our systems team stating that they were running low on Disk Space...  Read more...

By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.  Read more...

 A colleague pointed out a site that collects a lot of job posting data and exposes graphs - so I've taken...  Read more...

By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.  Read more...

I have not worked with SQL Server 7.0 in a loooong time.  So when I received a call from a...  Read more...

The new HierarchyID datatype in SQL Server 2008 has captured my interest lately. I’ve been working on a presentation that...  Read more...

SQL Server is so large and complex that it's like an operating system. In fact, there the core engine is often referred to as the "SQL OS" by Microsoft developers. Steve Jones would like to see SQL Server as it's own OS at some point.  Read more...

SQL Server is so large and complex that it's like an operating system. In fact, there the core engine is often referred to as the "SQL OS" by Microsoft developers. Steve Jones would like to see SQL Server as it's own OS at some point.  Read more...

SQL Server is so large and complex that it's like an operating system. In fact, there the core engine is often referred to as the "SQL OS" by Microsoft developers. Steve Jones would like to see SQL Server as it's own OS at some point.  Read more...

Find the country, region and city of a user from an IP address using SQL Server. Oscar Garcia provides some code and resources if you want to dig into your analytics on your own.  Read more...

Modeling and programming a neural Network in SQL Server from new author Silvia Cobialca. Learn how you might be able to implement this AI construct in SQL Server to make predictions.  Read more...

Many DBAs need to work with multiple platforms. New author Jagan Kumar brings us an article that helps to explain Oracle's architecture for those people used to working with SQL Server.  Read more...