Microsoft SQL Server

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 Internet and the availability of applications, the security of data, databases, and database servers has…

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 Log Buffer contains numerous flavors from Oracle, SQL Server and MySQL.

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 bloggers are no different. Enjoy this edition of Log Buffer.

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 filtered indexes and how they look like from a storage perspective. If you look at…

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 MySQL now have new things to offer. This Log Buffer shares that excitement and anticipation.

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 indexes looked like using DBCC PAGE during the presentation, but held back because it deserves…

Update on Home Learning Lab – Hyper-V

This is an update on my “Setting up a home learning lab” post. I have recently decided to upgrade the host OS on my desktop to Windows 8 Professional so I could check out Hyper-V as a virtualization platform and get to know Windows 8 better. Windows Server 2012 would have been my first choice,…

Page 10 of 50« First Page...89101112...20...Last Page »