Tag: Microsoft SQL Server

Log Buffer #331, A Carnival of the Vanities for DBAs

More and more blogs are springing up to cover database technologies. This ethereal Log Buffer Edition yet again cherishes this spectacular growth and offers a few links from the Oracle, SQL Server, and MySQL arenas.

Read More >

How to Secure Microsoft SQL Server

Security! This is a top-of-mind word for every concerned person when it comes to storing,  accessing, and sharing data, databases, or database servers. When applications are running in a restricted area, they are less likely to be exploited. However, with the increasing popularity of the…

Read More >

Log Buffer #330, A Carnival of the Vanities for DBAs

This Log Buffer Edition marvels at the ease, simplicity, and power of the database bloggers as they go about their adventures in the realms of Oracle, SQL Server, and MySQL.

Read More >

Log Buffer #329, A Carnival of the Vanities for DBAs

In this Log Buffer, you have naan bread, two types of roti, pasta, Karachi biryani, Chiken Tandoori, Beef tikka, eggplant masala, mixed pickles, French pastry with some elixir to wash all of it down. Yes, once again, this edition of…

Read More >

Log Buffer #328, A Carnival of the Vanities for DBAs

There is a tsunami of blog posts out there as Oracle has made public its 12c database and SQL Server and MySQL with numerous new offerings. This Log Buffer Edition covers a few salient blog posts.

Read More >

“Thou Shalt Configure MAXDOP For SharePoint 2013” Is No Longer Needed

Last year I started to get involved in the SharePoint community, particularly the SharePoint Saturday events. As a SQL Server DBA, I thought that SharePoint administrators needed to have a fair understanding of the underlying database because it is the…

Read More >

Log Buffer #327, A Carnival of the Vanities for DBAs

Nelson Mandela, The Madiba, said: ” There is nothing like returning to a place that remains unchanged to find the ways in which you yourself have altered.” Bloggers return to their blogs to experience the same charming thing, and database…

Read More >

How Filtered Indexes Look Like (Part 2)

In the first part of this series on Filtered Indexes, I talked about how SQL Server navigates through the index structure and used a clustered index as an example to demonstrate how the process works. To continue this series, we’ll look at…

Read More >

Log Buffer #326, A Carnival of the Vanities for DBAs

Just like the new car model excites the car enthusiasts, the new version of the database products fascinates the database professionals. A plethora of blog posts sprung up as the new versions of databases are released. Oracle, SQL Server, and…

Read More >

How Filtered Indexes Look Like (Part 1)

“During one of my SQL Server Index Internals presentation, an attendee asked me how filtered indexes look like and if they are stored exactly the way the traditional indexes are. I was tempted to show the internals of how filtered…

Read More >
Page 10 of 50« First Page...89101112...20...Last Page »