Thought I’d share a script I use to reset services nightly. This script will also e-mail if something goes wrong on the restart (which hasn’t ever been the case so far). This specific reason I built this is for a Tomcat server that has some problems with errand threads (I didn’t build it and can’t… Read More »
So a few months ago I posted about sleep apnea and my experiences in getting diagnosed and treated. It’s been about 3 months now and I have to say it took about 2 months to totally get used to the mask at night (see pic). One thing for me that was interesting is that it… Read More »
Had an idea the other day that it might be nice to be able to grab tweets based on a keyword and populate a SQL Server table. So I put together the following simple PowerShell script to do just that. First I create “tweet” table under a database called TwitterDB: [sql] CREATE TABLE [dbo].[tweets]( [published]… Read More »
Since the event was to be held at Mr. Biggs Family Fun Center my wife and I decided to make a day of it and pack up the kids and head down to Colorado Springs for SQL Saturday #66. We began the day early and hit the road at 6am to get down there. At… Read More »
So I’ve been playing around a bit with ASP.NET MVC lately and the ADO.NET Entity Data Model piece in Visual Studio. Being of a Dev/DBA mind I started to wonder what effect there was (if any) by willy-nilly adding all the tables of a given database to the Entity Data Model Diagram. Would it add… Read More »
A simple explanation is a stored procedure is a bit of T-SQL code that can take input parameters and is intended for use in queries that are regularly executed against SQL Server. It is “stored” within the database engine (hence the name). I’m not going to cover all of the benefits here, but I wanted… Read More »
