While it’s rather easy to force drop a database from SQL Server Management Studio’s UI, it’s just as easy to script it out:
ALTER DATABASE [YOUR-DATABASE-NAME] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE [YOUR-DATABASE-NAME]
CREATE DATABASE [YOUR-DATABASE-NAME]
If you had the opportunity to attend my presentation at the 2015 NEWCodeCamp, thank you for coming out to see me. You’ll find the abstract, presentation, and additional resources in this post.
Chicago, are you ready for some sass? I’ll be speaking at Chicago Code Camp on April 18, 2015!
I’ll be giving my relatively new presentation on SASS: Make a SASSy CSS Cocktail: Bourbon and Bitters Served Neat.
More information can be found at the Chicago Code Camp site.
Microsoft Azure isn’t just an amazing platform for ASP.NET, it’s also an excellent platform for hosting the world’s most popular blogging engine: WordPress. With WordPress powering 19% of the web and Microsoft Azure adding more services at amazing price points, it’s a no-brainer to combine the two. Leave your traditional shared webhost behind and look to the cloud.
In this video, we’ll walk through creating a new, git-driven WordPress installation running as a Microsoft Azure Website. We’ll also tie into other cloud services, such as Azure Block Blob Storage for storing media, SendGrid for sending emails, and ClearDB for our database. You’ll be ready to launch to the cloud in no time!
Update: With this week’s Azure announcements, some things are slightly different from what’s presented in the video. Main examples: websites are now web apps, WordPress is now a template you have to search for, Web Hosting Plans are now called App Service Plans.
If you had the opportunity to attend my presentation at the 2015 GRDevDay, thank you for coming out to see me. You’ll find the abstract, presentation, and additional resources in this post.
Another interesting data-tier application export exception: FillFactor is not supported when used as part of a data package.
Use the following query to identify the problem indexes:
SELECT OBJECT_NAME(i.object_id) AS TableName,
c.[name] AS ColumnName,
i.[name] AS IndexName,
i.fill_factor AS [FillFactor]
FROM sys.indexes i
INNER JOIN sys.index_columns ic ON ic.object_id = i.object_id AND ic.index_id = i.index_id
INNER JOIN sys.columns c ON c.object_id = ic.object_id AND c.column_id = ic.index_column_id
WHERE i.Fill_factor != 0
Then, one-by-one, bring up the designer for each table that has an offending index. Right-click the designer and bring up the Indexes/Keys… dialog. Find the offending index, then change its Fill Specification -> Fill Factor property to 0. Close the dialog and save the table.
Northeast Wisconsiners, book your calendars! I’ll be speaking at the NEWCodeCamp on March 28th.
I’m happy to announce that I’ll be speaking again this year at GR DevDay!
Two of my submissions were chosen:
- Make a SASSy CSS Cocktail: Bourbon and Bitters Served Neat
- Taking a Small Blog to the Big Cloud: WordPress on Azure
If you want to check out my sessions, the meetup is March 21, 2015. More info can be found at the GR DevDay site.
Yesterday I had tweeted about some awesome news, but then I failed to actually follow up. Sorry about that.
The news is: I’ve been promoted to a Senior Software Engineer. After just a year at Skyline Technologies, I’ve been able to get stuff done, make an impression, and move on up.
Thank you to my manager and director for vouching for me to the leadership team; it’s amazing to work on such a great team and to be recognized for my contributions. And of course thanks to the leadership team for agreeing with them and giving the thumbs up! And probably the biggest thank you goes to my coworkers, peers, and clients that all gave me stellar reviews (that made for excellent justification material). Blessed, I am.
So far it’s been an awesome year at Skyline, and I’m looking forward to many more. On to the future! Continue reading…
It’s not uncommon to receive recruiter invites on LinkedIn and other career-oriented sites, often asking for interest in job opportunities and sharing current job experiences. For the first time, however, I received a “sneaky” message: Continue reading…