 |
Blog
|
|
|

|
|
 |
Blog |
 |
| -->
 |
Archive for the ‘SQLServerPedia Syndication’ Category
Tuesday, August 2nd, 2011

In this podcast on the uber-popular podcast “RunAs Radio”, host Richard Campbell asks me about what topics are of particular interest at Tech-Ed 2011, focusing the discussion on cloud and SQL Server “Denali”
You can download the MP3 version of the podcast or the transcript here.
Tags: cloud computing, Denali, FutureWatch Posted in Databases, Interviews, Opinion, SQL Server, SQLServerPedia Syndication, Trends | 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 »
Thursday, July 21st, 2011
I read too much, and that, my friends, is an entirely separate topic for a blog post. But I thought I’d share with you a little more about what I’m reading because sometimes, if I’m lucky, it might be something you’d enjoy too.
So I’m going to start sharing what I’m reading at least once per week, partly so that I don’t firehose too many reading links directly into your brain (where I to do it say once per month) and partly to solidify in my own mind the information that I’m reviewing. So here are a few good links for the seven days leading up to July 22, 2001:
- Microsoft and Whitehouse partnership on BigData: BigData isn’t a particularly new concept. But I was intrigued to learn that the National Science Foundation, Microsoft, and 13 other teams were partnering on developing better BigData analytics for lots of government data from activities such as healthcare, economic development, education, transportation, and the power grid. Cools stuff! Plus, Microsoft has developed a new tool called Project Daytona to better harness the power of the cloud, in general, and Windows Azure, specifically.
- While we’re on the topic of Federal IT in the Cloud be sure to read this linked article from ComputerWorld. Say what you will about our government, but putting government IT in the cloud and increasing both its transparency and availability will make a huge difference in how the Federal government will be able to service the public. We’re talking as big a difference as corporations experienced between the “catalog on the web” experience of the 1990′s to the Web2.0 experience of today.
- If you’re the social media type, give this article a read discussing the Power of Hashtags in Social Media.
- The Register, of the UK, whose tagline is “Biting the hand that feeds IT” has a great article on a spat over database technologies between the IT sage Michael Stonebreaker and Google. It’s a great read if for no other reason than to prove that databases are worth fighting over.
- And if you think Microsoft is still towing the relational database barge without thinking about other technologies, you need to read up on Projects Dryad and Daytona.
- Finally, I’m still getting lots of questions about when and where to limit SQL Server’s Max Degrees of Parallelism. Be sure to read Microsoft’s Recommendations and Guidelines for ‘max degree of parallelism’ configuration option here.
And just because so many of us in IT are closet or former musicians, there’s Live Guitar Lessons with Steven Krenz, sponsored by my hometown boyz at Gibson Guitar.
Got a favorite article or tool tip? Let me know! Enjoy,
-Kev
Follow me on Twitter.
Posted in Administration, BigData, Challenges, Cloud, Cool Technologies, Databases, Gov2.0, IO, NoSQL, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Tips & Tricks, Tool Time, Trends, Virtualization, Web2.0 | 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 »
Friday, July 8th, 2011
I have to confess that I’m incredibly excited about BigData. I haven’t been this excited about new innovations in IT since relational databases first appeared on the scene early in my career. But what is BigData?
Back in those days, I can still feel the echos of adrenaline when I was hired to work on a NASA project that would involve over 100Mb of data. ONE HUNDRED MEGABYTES! Good grief, that was fantastically huge to us on the team. (That database was over 130Mb when I finally moved on to another project). And remember – PC software was installed using 640Kb floppy disks at the time. In fact, my Oracle v5 instance required shuffling through about a dozen floppy disks to get the thing installed on a 286 IBM PC.
BigData today takes on an entirely meaning as database sizes scale into the petabytes. But the emphasis is still the same today as it was back in the 1980′s – turning data into actionable information. However, with BigData, we can achieve amazing new insight from this data and mine for tidbits that would never have seen the light of day with smaller data sets.
The two major themes to remember about big data are 1) the more data you have on a given domain, the more power you have, 2) the better the analysis you can perform on the data, the more power you have. In fact, theme 2 might be the most important thing to consider because lots of data is meaningless unless you can extract knowledge from it. And that’s where better analytical techniques come into play.
Here are some articles about Big Data that you might enjoy:
Let me know what you think. Best regards,
-Kev
Tags: Best Practices, Big Data, Career, cloud computing, DBA, FutureWatch, SQL Server 2008 R2 Posted in Administration, BigData, Challenges, Databases, NoSQL, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post | No Comments »
Monday, June 27th, 2011
First off – the Pain of the Week webcast series has been renamed. It’s now known as The Expert’s Perspective. Please join us for future webcasts and, if you’re interested in speaking, drop me a note to see if we can get you on the roster!
The bigger your databases get, the longer backups take. That doesn’t really seem like a huge problem — until disaster strikes and you need to restore your databases as fast as possible.
Join my buddy Brent Ozar (blog | twitter), a Microsoft Certified Master of SQL Server and good friend, as he reveals ways to make these critically important maintenance tasks run faster.
You’ll discover:
- Why Instant File Initialization is so important for restores
- How to use DMVs to check restore progress
- How to find the bottleneck while you’re backing up or restoring data
Watch the recorded presentation at http://www.quest.com/events/ListDetails.aspx?ContentID=13358!
Enjoy!
-Kev
Tags: Backup & Recovery, Best Practices, DBA, Performance, Video Posted in Administration, Databases, Performance, SQL Server, SQLServerPedia Syndication, Tips & Tricks | No Comments »
Thursday, June 2nd, 2011
Several attendees at the SQLRally were asking about NoSQL (“Not Only SQL”) and its benefits. This article gives a quick overview: HERE.
Also, two good resources have come out from my friend Guy Harrison. This piece on Cassandra, one of the most popular NoSQL databases, was published a while back in Database Trends and Applications Magazine. I also really liked these entries from Guy at TechRepublic and TechTarget. Guy also had the good fortune of having one of his articles published on GigaOm and then picked up in the New York Times Technology section.
The article, titled “Real World NoSQL: HBase at Trend Micro,” is the first in a five-part series Guy wrote, spotlighting NoSQL (non-relational) database deployments at five different companies. The other good learning experience for me was hearing about GigaOm for the first time. GigaOm, now on my reading list, is considered an influential and prestigious publication in the NoSQL realm.
Let me know what you think. Enjoy!
-Kev
~~~
Twitter at kekline
More content on my Blog
Tags: Azure, cloud computing, NoSQL Posted in BigData, Cool Technologies, Databases, DBTA, NoSQL, SQL Server, SQLMag, SQLServerPedia Syndication | 1 Comment »
Tuesday, May 31st, 2011
Interested in my various performance tuning and troubleshooting videos about SQL Server? These videos feature my good buddies (and uber-SQL Server experts) Brent Ozar (blog | twitter) and Buck Woody (blog | twitter). View these insight-packed training videos from our SQL Server training events originally presented on March 3 and July 21 of 2010:HERE.
You can watch the videos now at the URL above or order a DVD, shipped free of charge in the USA and Canada, HERE.
Enjoy!
-Kev
~~~
Twitter at kekline
More content on my Blog
Tags: Best Practices, DBA, DMV, Internals, Monitoring, Performance, Quest Software, SQL Server 2008 R2, Video Posted in Administration, Challenges, Databases, IO, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication | 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 »
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 »
|
|
 |
|
|