-
Recent Posts
Recent Comments
- paulwinans on Hard Coded Values
- Dejan on Hard Coded Values
- paulwinans on SQL Licensing and the Cluster
- paulwinans on Leadership
- paulwinans on Where Are All The People Who Want to be a DBA?
Archives
- February 2018
- July 2017
- July 2016
- May 2016
- October 2015
- September 2015
- August 2015
- July 2015
- May 2015
- April 2015
- March 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- September 2014
- August 2014
- July 2014
- June 2014
- March 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- April 2013
- March 2013
- October 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- February 2012
- January 2012
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- May 2009
Categories
Meta
Author Archives: paulwinans
SSRS Subscription Owners
We have to be sure subscription owners are not going to leave and make the subscriptions they own fail. Here is a way to make this information visible easily. For the reporting group I made a stored procedure which takes … Continue reading
Posted in SQL, SSRS
2 Comments
What is Tidal Enterprise Scheduler?
Tidal Enterprise Scheduler is a Cisco product which allows for many things SQL Agent can’t easily do, such as allowing for cross server job dependencies; removal of a single job execution without cancelling the entire schedule; file triggered events; passing parameters from one job to another; … Continue reading
Posted in SQL, Tidal Enterprise Scheduler
Leave a comment
Making SSMS Work for You
I love taking advantage of the customizable keyboard shortcuts in SSMS. You can put in stored procedures to be run when you press certain key combinations. For example, I have sp_helptext run when I press CTRL+5 and an expanded version … Continue reading
Posted in Configuration, DBA
Leave a comment
Meetings
We had a discussion at work about meetings, specifically the level of detail needed during round robins being used as an FYI technique. I like the idea that it is a formal time to bring up some ad hoc topic. … Continue reading
Posted in Leadership
Leave a comment
Weather Check
A favorite sanity barometer is how many emails are in my inbox. No joke: I know everything is copasetic when I have no more than 50. Too many more and it is time to stop, prioritize and communicate.
Posted in Leadership, Other Things
Leave a comment
Data Compression
If you’re not compressing your tables and indexes, read this: http://www.brentozar.com/archive/2009/08/sql-server-data-compression-its-a-party/. We were able to add a complete additional dev region with the disk savings. And backups are compressable too!
Posted in DBA
Leave a comment
Where Are All The People Who Want to be a DBA?
I have never met anyone who took me up on learning to be a dba. I really like the work myself, figure others would too, and have gone through some genuine lengths to provide opportunities. For example, I volunteered at … Continue reading
Posted in DBA
2 Comments
Local Policy Settings
I have a bunch of sql servers and don’t know whether the required local policies are in place to take advantage of the available memory. I first thought checking who could do what could be found via WMI but nothing … Continue reading
Posted in DBA
Leave a comment
Having a number two for log backups
The server which holds the production log backups was not reponding yesterday. It was a pain to go into the tran log backup jobs and manually change them to a new share until the problem was resolved, so I decided … Continue reading
Posted in Day to day
Leave a comment
Changing The Port Used By SQL Server
We need to change the port sql server uses from the default to… something else. Towards that end I want to make aliases on all the end user computers and other sql servers so they can still connect without problems. … Continue reading
Posted in Configuration, DBA
Leave a comment