 |
Blog
|
|
|
|
|
 |
Blog |
 |
| -->
 |
Posts Tagged ‘Developer’
Tuesday, August 16th, 2011
In last month’s column, “2012 Might Really Be the End of the World as We Know It,” I described a number of major developments in the IT industry that are likely to disrupt the life of database professionals everywhere. I categorize those four disruptors – virtualization, cloud computing, solid state drives (SSD), and advanced multi-core CPUs – into two broad groups. I’m going to continue an analysis of these disruptive technologies in inverse order. Today, let’s discuss SSDs.
[READ MORE ON DATABASE TRENDS & APPLICATIONS ]
Tags: Best Practices, Career, DBA, DBTA, Developer, FutureWatch, Goals, Virtualization
Posted in Administration, Challenges, Cool Technologies, Databases, IO, Opinion, SQL Server, SQLMag, SQLServerPedia Syndication, Virtualization | No Comments »
Tuesday, August 2nd, 2011
EPIC FAIL! This was supposed to go out last week. But I didn’t schedule it properly, so I’d just like to point out that there are lots of other great webcasts to watch at the Pragmatic Works webcast URL below. Plus, my session will be available via streaming by the end of the week. And thanks the the 1600 folks who registered!
-=-=-=-
Come join me on Tuesday, August 2, 2011 11:00 AM – 12:00 PM EDT for a free webcast covering the internals and architecture of Microsoft SQL Server. It’s not everyday that a dry topic like this is presented in a fun and easy to understand format, so get in while the gettin’ is good. :^)
Registration is free, thanks to the fine folks at Pragmatic Works.
REGISTER HERE
And don’t forget to check out all of Pragmatic Works’ other free webcasts. It’s great stuff and it’s FREE!
Enjoy,
-Kev
Follow me on Twitter
Tags: Best Practices, DBA, Developer, Internals, Monitoring, Performance, SQL Server 2008 R2
Posted in Administration, Databases, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication | No Comments »
Wednesday, July 20th, 2011
Remote Desktop Services Component Architecture Poster
Grab your own poster! A visual guide to key Remote Desktop Services technologies in Windows Server 2008R2
Virtually Free
Get the latest update rollup package for the Hyper-V role in Windows Server 2008 R2 and be sure to bookmark the Windows Virtualization Team Blog. Be sure to check out blog World Simplified is a Virtual World. And doncha evah neglect application virtualization, such as the goodness at the App-V Product Team Blog.
Let’s Optimize Some Desktops (Assuming You Have Gone Full Cloud Yet)
Check out The Official Microsoft Desktop Optimization Pack (MDOP) Blog where you can get cool tools like the Diagnostics and Recovery Toolset (DART), currently in its v7 beta release.
 We Can Always Perform a Little Better
Have you checked out the Ask the Performance Team blog yet. You should! Then there’s the Microsoft Enterprise Networking Team blog. And if you’re looking for help with the Windows Server Core, be sure to check out the Ask the Core Team blog. Excellent stuff!
As the Tool Time columnist at SQL Server Magazine, I’m always on the lookout for great free tools that get on-going support from their creators. One common experience is finding a nice debugging tool, only to discover that there’s no information on how to interpret the debugger result sets! (SQLIOSim anyone?) That’s why I love the Microsoft Advanced Windows Debugging and Troubleshooting blog. Another must-have on your Favorites list.
Enjoy!
-Kev
Follow me on Twitter
Tags: Best Practices, cloud computing, DBA, Debugging, Developer, Performance, SQL Server 2008 R2, Tools, Troubleshooting, Virtualization, Windows
Posted in Administration, Cloud, Cool Technologies, Databases, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Tips & Tricks, Tool Time | No Comments »
Thursday, May 12th, 2011
I first wrote about Mladen Prajdic’s excellent tool in my Tool Time column at SQL Server Magazine HERE. The tool is a nice plug-in to SSMS and definitely worth having. If you’ve never installed it or have only installed an older version, but sure to pick up the newest release. Here’s Mladen’s press release complete with hyperlink for the tool:
SSMS Tools Pack 1.9.4 is out! Now with SQL Server 2011 (Denali) CTP1 support.
As Mladen says:
…this release adds support for SQL Server 2011 (Denali) CTP1 and fixes a few bugs. Because of the new SSMS shell in SQL 2011 CTP1 the SSMS Tools Pack 1.9.4 doesn’t have regions and debug sections functionality for now. The fixed bugs are: A bug that prevented to create insert statements for a database A bug that didn’t script commas as decimal points correctly for non US settings….
Enjoy!
-Kev
Tags: DBA, Denali, Developer, SQL Server 2008 R2, SQLMag
Posted in Databases, SQL Server, SQLMag, SQLServerPedia Syndication, Tool Time | No Comments »
Wednesday, May 4th, 2011
The Toad for Sybase webcast is now available on-demand. Don’t have Toad for Sybase? Get it HERE while it’s a free beta.
There are two ways to access the webcast:
1. Quest.com - requires a username/password and gets tracked
2. ToadWorld – for quick viewing
Go with option two if you don’t wanna be tracked. Lot’s more Toad for Sybase goodies HERE.
Tags: DBA, Developer, Quest Software
Posted in Databases | No Comments »
Tuesday, May 3rd, 2011
On my recent trip to SQLBits with subsequent visits to Dublin, Cologne, and Malmo (southern Sweden), I enjoyed a chance to meet several SQL Server MVPs, including Peter Larsson and Thomas Ivarsson.
Among them, I enjoyed Johan Ahlen’s article on Pulling real-time data from Twitter using StreamInsight. You can Find Johan’s blog here. I also enjoyed several other conversations, such as the one I had with Feodor Georgiev (blog). I particularly enjoyed Feodor’s guest post on SQLAuthority.com about waits in the round-trip loop from client to server back to client available HERE.
There’s a rumor going around (wink, wink – nudge, nudge) that the Scandinavians will be holding a SQLRally in the fall. I look forward to get back soon, but I’m hoping against hope that it’s still warm in November.
~~~
Tags: DBA, Developer, MVP, StreamInsight
Posted in Administration, Challenges, Databases, Presentations | No Comments »
Monday, May 2nd, 2011
There are so many great tools out there for data professionals using Microsoft SQL Server. I really like to see all of these great tools made free to the public. On the other hand, I’m bummed that the tools are cast about in a very decentralized fashion. If you haven’t done migrations before, you might want to start with these good white papers first.
Here are a hand full of cool migration tools worth mentioning:
Microsoft SQL Server Migration Assistant (SSMA) for MySQL: Migrate from MySQL to SQL Azure or SQL Server with ease. Plus, here are a few related Knowledge Base (KB) articles:
Azure SQL Service: Database Migration To Sql Azure
http://support.microsoft.com/kb/2212855/en-US
Azure SQL Service: Database Migration To Sql Azure
http://support.microsoft.com/kb/2212990/en-US
Azure SQL Service: Developing Applications For Sql Azure
http://support.microsoft.com/kb/2213496/en-US
SQL Server Migration Assistant (SSMA) for Sybase: Migrate from Sybase ASE to SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.
SQL Server Migration Assistant (SSMA) for Microsoft Access: Migrate from Access to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
SQL Server Migration Assistant (SSMA) for Oracle: Migrate from Oracle to SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2. I’m thinking about installing it on my SQL Servers even without even needing to migrate existing Oracle databases to SQL Server. Why? Well as an old Oracle hand, I came to really enjoy quite a few Oracle PL/SQL system packages (kind’a like a SQL Server system stored procedure, but often more powerful). As it turns out SSMA-Oracle includes stored procedures, extended stored procedures, and CLR routines that reproduce the functionality in most all of the cool and powerful Oracle packages like DBMS_PIPES. It’d be nice to have those on my SQL Servers just because I know them and like them.
Microsoft Drivers for PHP for SQL Server 2.0: Microsoft Drivers for PHP for SQL Server – and PHP is good.
Microsoft Services for Mission Critical Customers: Many enterprise customers running mission critical applications on SQL Server have asked for more – more service and support for their environments. This is an add-on that costs extra, but it’s worth it for those running the systems that keep the company in business.
If you’ve tried any of these tools out, I’m keen to hear your experiences. Did they work well for you? Did they work, though poorly? Did they fail utterly? Inquiring minds want to know.
~~~
Tags: cloud computing, DBA, Developer, MS-Access, MySQL, Oracle, PHP, SQL Azure, SQL Server 2008 R2, Sybase, Tools, Tools & Scripts, Transact-SQL Programming
Posted in Administration, Challenges, Databases, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks, Tool Time, Transact-SQL Programming, Virtualization | No Comments »
Friday, April 29th, 2011
I had a very interesting conversation recently with a good friend of mine. She’s at the top of her game as a first class enterprise DBA in a major medical institution. She was interested in my career advice because she’d recently received an unsolicited invitation for a higher paying job in the business intelligence (BI) field. While I won’t talk much more about the specifics of that conversation, it’s not a unique conversation. In fact, I gave an interview to SearchSQLServer.com a while back about how DBA career paths are more and more leading into an even better paying career in business intelligence. Check out the interview HERE.
~~~
Tags: Business Intelligence, Career, DBA, Developer, SQL Server 2008 R2, SSAS
Posted in Administration, Databases, Opinion, Professional Development, SQLMag, SQLServerPedia Syndication | 1 Comment »
Thursday, April 28th, 2011
Many thanks to Microsoft SQL Server MVP Andy Leonard (blog | twitter) for conducting a series of interviews of prominent SQL Server types, including me. The interview found here.
~~~
Tags: Career, DBA, Developer, MVP, Professional Development, Writing
Posted in Databases, Interviews, SQL Server, SQLMag, SQLServerPedia Syndication | No Comments »
Wednesday, April 27th, 2011
The Toad for SQL Server review that was recently conducted for SQL Server Magazine was published online – and we got 5 out of 5 diamonds!
This is an improvement from the 4.5/5 stars Michael Campbell gave the product in a 2009 review. The review is very positive, with Michael citing the product’s highly customizable management and development solution, and writes that it “one-ups SSMS by including server, schema, and data comparison tools, a log reader, and a wide assortment of other options, capabilities, and utilities.”
See the full review below or by clicking the link here: Toad for SQL Server 5.0 Professional Edition.
Also, don’t forget to check out Toad for Cloud Databases and NoSQL databases currently in beta.
Tags: DBA, Developer, Quest Software, Toad
Posted in Cloud, Databases, NoSQL, SQL Server, TCD blog post | No Comments »
|
|
 |
|
|
