SQLServerCentral Syndication
All posts in this category get syndicated to SQLServerCentral.com
-
PASS 2012 NomCom
I’m officially on the slate and running for the PASS 2012 Nomination Committee! I love the SQL Community and everything it embodies. I am very involved at the local and regional level and gained a unique view into PASS working on SQLRally. I know most of the current and past board members and those relationships have…
-
SQLRally Dallas Slides
I was fortunate enough to get to present not 1 but 2 sessions at SQLRally 2012 in Dallas last week. As a core organizer of the event, this really made it a special week to present twice and see it all come together. My first session was a community choice pick. The second session I got…
-
SQLRally Can’t Miss Events
Things have been quiet around here lately and I have a one word explanation….SQLRally. There’s work and family and several other community commitments, but mostly SQLRally. The good news is that the time has come and I couldn’t be more excited. I haven’t been to a SQLSaturday or community event in months and I’m having serious…
-
Configure Anti-Virus on your SQL Server
This week I had an application team report the error “SQL Connection Lost”. Fortunately they also reported the exact times of occurrence, which made it much easier to hunt down. I did some digging through the SQL logs and DMVs, but did not find anything that indicated SQL was dropping the connection. I also did…
-
Learn Mirroring with me at SQLRally
I just found out that I will be speaking at SQLRally Dallas in May. I submitted 3 sessions. As an event organizer, all 3 automatically went to community vote. I am very excited that my Mirroring session was voted in. Thank you to everyone who voted for me! Mirroring Start to Finish Mirroring can be…
-
Speaking at PASS DBA Virtual Chapter
I will be speaking for the PASS DBA Virtual Chapter on February 22nd, 2012. I will be delivering my presentation on Mirroring. If you have not checked out the virtual chapters that PASS has, then you need to Go Check Them Out. These chapters are designed to fill the gap for areas of the country that…
-
Performance VC Feb Meeting
Jes Borland will be speaking for the Performance Virtual Chapter this month. Don’t miss out on this free training. Here are the details and click the link to visit the chapter website for the LiveMeeting link and to add to your calendar: Filegroups: Putting The Pieces Together by Jes Borland February 23, 2012 at…
-
SQLCruise: The Trident
Move over Poseidon. I’m hitting the sea with my own trident (assuming I can get it through the TSA). My trident is made from the culmination of my favorite three things. My wife, SQL Server, and cruising. Let me explain. Back in October of last year, Idera ran a contest called the “Get a life…
-
PASS Performance VC Reboot
The PASS Performance Virtual chapter is getting a reboot. We all know that responsibilities and schedules change, and that meant this chapter needed some additional hands on deck. Erin Stellato (Blog|Twitter) valiantly volunteered to take the helm and she put out an SOS for volunteers. The response was great with some wonderful people volunteering to help. I…
-
Setup Alerts for PBM
PBM raises errors for policy violations. We can create alerts on those errors to be notified of policy violations. In order to setup alerts on these errors there are three prerequisites. Note that violations for the “On Demand” evaluation mode do not raise errors. A policy must be set to “Enabled” to raise an error,…
-
SQLRally 2012 Registration Open
The Professional Association for SQL Server and the North Texas SQL Server User Group have been working hard behind the scenes to bring SQLRally 2012 in Dallas Texas to the SQL Community. We are excited to announce that event registration opens November 30, 2011. Make sure to get registered soon and take advantage of the…
-
See if Auto Create Statistics is enabled using PBM
We will walk through creating a policy to evaluate the status of “Auto Create Statistics” on our server named “File2”. First we need to open SQL Server Management Studio and connect to our server. Then we need to enable Policy Management by expanding the Management node, right clicking on Policy Management, and selecting Enable. You…