Microsoft SQL Server 2008 is the most recent version of the Redmond, Wash., company's data management and business intelligence platform. According to Microsoft, the version provides new capabilities ...

SQL Server has supported VLDBs (very large databases) for some time now. Back in the SQL Server 2000 days, I recall hearing multi-terabyte databases were unusual but doable. Now, they are commonplace, ...

Joel Snyder, Ph.D., is a senior IT consultant with 30 years of practice. An internationally recognized expert in the areas of security, messaging and networks, Dr. Snyder is a popular speaker and ...

Because SQL Server manages security identifiers (SIDs) for any user logging into SQL Server, you risk "orphaning" users when you do a restore. It's a common problem, and here's why. Typically, ...

When it comes to Microsoft SQL Server 2008, what can you expect? SQL Server, code named Katmai, is – as its name suggests — due out later this year. Question is why should you care? Now I could talk ...

AI thrives on data but feeding it the right data is harder than it seems. As enterprises scale their AI initiatives, they face the challenge of managing diverse data pipelines, ensuring proximity to ...

Guys I'm going to be putting in a database mirroring solution for our Sharepoint 2007 farm. I will not be using SQL servers auto grow features instead I will manually set the size of all log files and ...

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...