I just posted a new blog entry on how I automate the shutdown and startup of Windows services. Check it out at http://www.sqlmag.com/blogs/tool-time.aspx. Be sure to let me know what you think and if you have your own unique methods for automating the control of Windows services! Many thanks, -Kevin -Twitter @kekline … [Read more...]
New on SQLMag – Automating the Startup and Shutdown of Windows Services
Filed Under: Administration, SQLServerPedia Syndication, Tool Time Tagged With: DBA, SQLMag, Tools & Scripts
New Interview and SQLMag ToolTime Blog Article on “SQLClue”
A neat new administration and configuration management tool for the SQL Server set. I especially like the Run Book features, because Run Books are the way us "oldtimers" like to run our IT infrastructure. My pal, Buck Woody, also likes Run Books (and really big explosions by the guys on MythBusters, but that's another discussion). Find all the details about the new tool, created by Bill Wunder, here. In addition, I'm honored and amazed that the team at RunAsRadio invited me to participate in interview #143. These are the same guys who also put together one of the best and longest … [Read more...]
Filed Under: Administration, On-Line Resources, Opinion, SQLServerPedia Syndication, Tool Time Tagged With: DBA, Monitoring, MVP, SQLMag, Tools & Scripts
The Awesomeness of ROBOCOPY Now at SQLMag
If you're like me, you've used Ctrl+C/Ctrl+V more than a time or two, but you've always felt a little dirty afterwards. Yeah, you can use the command-line COPY or XCOPY utilities. But they're decidedly 20th Century, much like some of the laundry still loitering under my office couch. So I spent a little time over the holidays cleaning up my file system by scripting a backup routine using the very cool and very free ROBOCOPY utility. Now, I've got a regularly scheduled job that, after the first run which captured all my files, only backs up new or changed files (and directories) while … [Read more...]
Filed Under: SQLServerPedia Syndication, Tool Time Tagged With: SQLMag, Tools, Tools & Scripts
Like PowerShell for SQL Server?
Check out my new Tool Time column in this month's SQL Server Magazine. It features some great new PowerShell scripts and information from Chad Miller (blog) who I had the pleasure to meet in person back in October of this year while speaking at the SQL Server of central Florida and at SQL Saturday #21. In addition, I'd like to point out a free utility called PowerGUI. If you're like me, the last thing you have time for is learning a new code like PowerShell. So I copped out and got the next best alternative to real code, the fancy and pretty drag-n-drop interface of PowerGUI. (Full … [Read more...]
Filed Under: SQLServerPedia Syndication, Tool Time Tagged With: CodePlex, SQLMag, Tools & Scripts
New at SQLMag – Disk2Vhd
I just posted a new entry on my SQLMag Tool Time blog that you might enjoy. Thanks to my friend and fellow MVP John Paul Cook for bringing Disk2Vhd to my attention on his blog. The free tool is enables migration of a physical machine (PM) to a virtual machine (VM), while the PM is running. You can download it from Microsoft here. John also has lots of other great information about VM migration here. Note that John's content relates to Hyper-V. So if you're looking for VMWare tools, keep looking. Of course, if you find similar free tools for VMWare, let us know by posting … [Read more...]
Filed Under: SQLServerPedia Syndication, Tool Time Tagged With: SQLMag, Tools & Scripts, Virtualization
Upcoming Seminar and SQL Saturday in Florida, Oct 13-17
Please join me for SQL Saturday #21 coming up on Saturday, October 17th. There are over 50 sessions on tap with great speakers from the area and across the nation. Some of the notable speakers include: Andy Leonard (blog here) Andy Warren (blog here) Brian Knight (blog here) Buck Woody (blog here) Chad Miller (blog here) Joe Celco (blog here) Joe Webb (blog here) Jonathan Kehayias (blog here) Kendal Van Dyke (blog here) Ken Simmons (blog here) Not only do we have SQL Saturday coming up, but Andy & company put together five world class seminars the week … [Read more...]
Filed Under: Conferences, PASS, Professional Development, SQLServerPedia Syndication, Transact-SQL Programming Tagged With: Performance, SQLMag, Transact-SQL Programming
New at SQLMag – TraceAnalyzer
I just posted a new entry on my SQLMag Tool Time blog that you might like to check out. I'm a big fan of Bill Graziano's ClearTrace tool, but perhaps you'll like the new tool from DBSophic, called TraceAnalyzer, even better? Compare the two and let me know here. Cheers, -Kevin Twitter @kekline … [Read more...]
Filed Under: SQLServerPedia Syndication, Tool Time Tagged With: SQLMag, Tools & Scripts
New Post on my SQLMag Blog – Free DMV Monitoring Tools
I've posted a new entry on my SQL Server Magazine blog about two free DMV monitoring tools available on CodePlex. Read the article here: http://www.sqlmag.com/Articles/ArticleID/102837/102837.html?Ad=1 Take a look at the two tools and let me know which you like better and why. Inquiring minds want to know! Cheers, -Kev … [Read more...]
Filed Under: SQLServerPedia Syndication, Tool Time Tagged With: CodePlex, DBA, DMV, Monitoring, Performance, SQLCAT, SQLMag
New Post on My SQL Server Magazine Blog
Just put up a new post detailing a new block discovery and alerting script from Yaniv Etrogi. Read my SQLMag blog describing free tools and scripts for SQL Server at: http://www.sqlmag.com/blog/index.cfm?action=blogindex&DepartmentID=965. Enjoy! -Kev Twitter @ kekline … [Read more...]
Filed Under: Tool Time Tagged With: Blocking, SQLMag, Tools & Scripts
