I installed Windows 8 recently and needed to activate it. I didn’t do this on the install since I didn’t have an Internet connection when I first set things up. This is a hardwired desktop, and I had to move it to my office to plug it in. However I… Read more
This weekend of SQL Saturday #183 in Albuquerque, NM. It’s the first SQL Saturday in that state, and it’s a relatively short drive from Colorado. Six hours from my house, S of Denver, and a nice city. My brother used to live there, and I made a few trips to… Read more
I’ve never felt the need to allow this, but I saw someone ask the questions recently. Suppose you had a view and you wanted to allow a user to grant permissions to this view to other users.
It’s not a weird edge case, but it’s just not one I’ve normally… Read more
In a recent post I showed how the file extension for a database doesn’t matter. It can be confusing, however, and you might wish to “fix” the filenames to conform to the proper extension. How can you do this?
Well, to change a file name, or location, you need to… Read more
I would hope that most of us have used a thesaurus at some point in our careers. These allow us to substitute words for one another, providing for richer and more interesting communication.
Do you know the basics of how to create a database? Hopefully you do and can do so without the GUI. However do you know the extensions are for database files? As of SQL Server 2012, these are the extensions:
- Main data file – .mdf
- Secondary data files – .ndf
Someone asked me on Twitter recently if I ran full regression tests before applying Cumulative Updates (CUs). I decided it wasn’t worth discussing in 140 character chunks, so I decided to jot a few notes down. I’ll also expand this to encompass Service Packs since these are almost CU rollups… Read more
There are numerous components to the Full-Text Search (FTS) subsystem in SQL Server that help provide efficient, relative answers to queries. Full-text Search is a little complex, and as I’ve been working with the system in an effort to learn more about it, I decided to document how a few… Read more
Brent Ozar Unlimited released v16 of this sp_blitz script, which is designed to run on a SQL Server instance and give you a quick, comprehensive report of the state of the instnace. It’s a great script, and if you have the chance to see Brent present on the script,… Read more
I’ve been looking for ways to improve the way I do my job, which is mostly writing and editing, but at a higher level it’s teaching people. That was the goal of SQLServerCentral, to help people learn about SQL Server and become better at their jobs.
Last summer I was… Read more
It’s T-SQL Time again, and this time it’s #38, from Jason Brimhall (b | t | li). The topic this month is Standing Firm. You are supposed to look at any of these words, and write something that fits with one of them.
This… Read more
I ran down the rabbit hole on transaction logs recently. I started with Paul Randal’s post over at the SQL Sentry blog on trimming the transaction log, then went to his video on log analysis. I also glanced at the posts on index cleaning and what index stats… Read more
I’ve been accepted to speak at SQL Saturday #183 in Albuquerque, NM on Feb 9, 2013. This is the first SQL Saturday in New Mexico, and I’m excited to drive down and meet the SQL Server pros down there.
My brother used to live in Albuquerque, and I’ve been there… Read more
I was reading a post from Paul Randal recently and noted that he recommends not changing the instance’s default fill factor. I agree, and you shouldn’t alter it. However if you aren’t sure if it’s been changed on any of your instances, here’s how to check it.
I’ll show both… Read more
“Rob? Tsk tsk tsk. That’s a naughty word. We never rob. We just sort of borrow a bit from those who can afford it. “
Full-text search is an interesting subsystem in SQL Server. It allows you to implement searches through a variety of text formats stored in SQL Server. This is a one of a series of posts that looks at different facets of full-text search.
What is a Stoplist?
A stoplist is a… Read more
Last Friday I went for a quick run before we packed up and headed to Steamboat Springs for a week’s vacation skiing with the family. Saturday I snowboarded, came back to the condo, found no treadmill, slippery, icy conditions on the roads, and just stopped running.
No fanfare, no complaints,… Read more
I’m on holiday, but I have a set of predictions for 2013 coming on Jan 1. This is a little notice in hopes that a few of you might join in to the meme and make a few predictions for 2013.
Database related, technology related, car related, write a few… Read more
I’m off again, taking a week in Steamboat Springs with my family for the Christmas holiday. We’re spending a week up there, including my oldest son who came back from Seattle to see us.
It seems like I’ve been gone a lot, with guest editorials and re-publishing old pieces in… Read more
I hadn’t used full-text indexing in production throughout my career. We hadn’t had the need in the applications I worked on, all of them depending on LIKE searches in specific, normalized data.
However I have always been interested in it and as I try to find data more often in… Read more