Archives: April 2012
As a blogger, you have several options available to you when it comes to writing posts. You can write them online, directly inside whatever platform you’re using, be it WordPress, Blogger, TypePad, etc. If you prefer to write posts offline, you can use a text editor like Word or WordPad… Read more
Lately I’ve taken to watching TED talks in the evening. They’re thought-provoking, usually entertaining, and, best of all when watching late at night, short. I have to control myself though, I could spend hours jumping from one great topic to another. Really, I should probably watch something less thought-provoking right… Read more
- It’s time to true-up with Microsoft, what are your current license counts?
- Operations needs to schedule maintenance on ServerY, what applications will be impacted?
- A developer wants to change the password for a certain login, what linked servers will be affected?
- Are there any databases that haven’t been…
Temporary Post Used For Theme Detection (a2bb2736-7786-4122-aa80-2ea5c4a91819 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (a9a8917a-7430-47c6-8534-f96e3e4e0618 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
Last time, I talked about how clients communicate with SQL Server through TDS endpoints and how to disable endpoints to prevent user access. Today we’ll see how we can configure SQL Server to listen on multiple ports through the use of user-defined endpoints.
Create a new TDS endpoint
There can… Read more
In the land of Oracle, if you want to prevent user access to your database, you stop the listener. Without that agent running, you can still connect to the database locally, via shared memory, but all TCP/IP connectivity is disabled. As a DBA, this is pretty handy if you need… Read more
Date: May 19, 2012
Location: SQLSaturday #119, Chicago
Ever thought about trying your hand at blogging? Or maybe you’ve started a blog but struggle with what to write about. We’ll take a beginner’s look at blogging and examine what makes a great blog, finding topics, finding your voice, building… Read more
As part of a project I’m currently involved with, we’re migrating a database to SQL Server 2008 and performing some internal updates to the schema and data. Once the database portion of the upgrade is complete, we’d like to update all database statistics before continuing.
On a large database, updating… Read more
We hear a lot about social media these days: Facebook, LinkedIn, Google+, Twitter, etc. More and more, we’re expected to participate, to put ourselves out there, on display for the world. How we present ourselves online has become just as important, and in some cases more important, than how we… Read more
I mentioned earlier this week that I’m working on a new presentation for SQLSaturday #119 next month. The talk revolves around common issues that new bloggers face, including reasons for not blogging. So far, I’ve compiled several common roadblocks, but I’d love to hear from you.
If you’ve thought about… Read more