http://www.sqlmag.com/authors/author/author/5030568/rsscomment/5030568en-USFri, 25 May 2012 10:25:15 GMTFri, 25 May 2012 10:25:15 GMThttp://www.sqlmag.com/article/internet-explorer2/internet-explorer-9-tips-142560#commentsAnchorTue, 22 May 2012 10:47:04 GMT
I'd like to add a tip that I consider essential to shoring up your privacy when browsing, and that's blocking third party cookies. The Wall Street Journal describes in detail how advertisers collect tons of information about you by planting cookies on your system. These aren't from the web but from third-party advertisers. Look in advanced privacy settings. In Chrome it's in settings, Under the hood, content settings. Highly recommended. - Sean (@shorinsean)]]>Sean DeubyTue, 22 May 2012 10:47:04 GMThttp://www.sqlmag.com/article/internet-explorer2/internet-explorer-9-tips-142560#commentsAnchorhttp://www.sqlmag.com/article/sql-server/8-free-sql-server-downloads-143088#commentsAnchorFri, 18 May 2012 11:03:33 GMT
Really useful article. I would like to mention one more free tool, which I have developed and released shortly: SSMSBoost add-in for SSMS (www.ssmsboost.com). It is focused on fixing SSMS handicaps that exist in SSMS for years and improves it's usability. Currently it focuses more on daily tasks of T-SQL developers and helps to navigate through the code (1-click scripting of objects directly from SQL Editor). Also Administrators will find it useful, as far as it allows to manage preferred SQL Connections and simply switch between them: same way as you previously switched between databases, but now also between different servers -through combo-box on the toolbar. So - check. It has even more features and user requests are welcome. ]]>Andrei RantsevichFri, 18 May 2012 11:03:33 GMThttp://www.sqlmag.com/article/sql-server/8-free-sql-server-downloads-143088#commentsAnchorhttp://www.sqlmag.com/article/sql-server/8-free-sql-server-downloads-143088#commentsAnchorWed, 16 May 2012 14:59:48 GMT
another cool free tool: http://www.nobhillsoft.com/dianalite.aspx searcs through sql code, parses it, tells you about errors and warnings, and does about million other things... ]]>yonisionWed, 16 May 2012 14:59:48 GMThttp://www.sqlmag.com/article/sql-server/8-free-sql-server-downloads-143088#commentsAnchorhttp://www.sqlmag.com/article/commentary/digital-sql-server-pro-142523#commentsAnchorSat, 05 May 2012 19:45:41 GMT
The hyperlinks in this commentary to other articles are returning a 404. For example, it looks like http://www.sqlmag.com/tabid/461/www.sqlmag.com/article/tsql/tsql-best-practices-141536 should be simply http://www.sqlmag.com/article/tsql/tsql-best-practices-141536 I am quite dissappointed. If I wanted a digital subscription, I would have saved my money and only had online access years ago. ]]>robert.johansonSat, 05 May 2012 19:45:41 GMThttp://www.sqlmag.com/article/commentary/digital-sql-server-pro-142523#commentsAnchorhttp://www.sqlmag.com/article/commentary/digital-sql-server-pro-142523#commentsAnchorThu, 03 May 2012 18:57:42 GMT
Agree with gonzalfe. The ad obscures the top of the article. Siurely, you can let users close the floating ad when we're done ignoring it.]]>bigpalookaThu, 03 May 2012 18:57:42 GMThttp://www.sqlmag.com/article/commentary/digital-sql-server-pro-142523#commentsAnchorhttp://www.sqlmag.com/article/commentary/digital-sql-server-pro-142523#commentsAnchorThu, 03 May 2012 08:49:02 GMT
The constantly changing advertising banner on the top of every article is extremely annoying! Please, consider putting it else where so as not to distract a user's attention in reading your magazine articles... sheesh....]]>gonzalfeThu, 03 May 2012 08:49:02 GMThttp://www.sqlmag.com/article/commentary/digital-sql-server-pro-142523#commentsAnchorhttp://www.sqlmag.com/article/sql-server/creating-sql-server-2012-installation-windows-server-core-142853#commentsAnchorMon, 23 Apr 2012 05:48:03 GMT
Excellent instructions! Very concise & much appreciated. (I suggest cutting and pasting into notepad and tailoring to your requirement)]]>bradashmoreMon, 23 Apr 2012 05:48:03 GMThttp://www.sqlmag.com/article/sql-server/creating-sql-server-2012-installation-windows-server-core-142853#commentsAnchorhttp://www.sqlmag.com/blog/michael-oteys-blog-21/system-center/microsoft-system-center-2012-enables-private-cloud-141932#commentsAnchorTue, 06 Mar 2012 02:13:21 GMT
nice to read]]>private cloudTue, 06 Mar 2012 02:13:21 GMThttp://www.sqlmag.com/blog/michael-oteys-blog-21/system-center/microsoft-system-center-2012-enables-private-cloud-141932#commentsAnchorhttp://www.sqlmag.com/article/cloud-computing2/top-ten-free-cloud-services#commentsAnchorSun, 26 Feb 2012 12:17:41 GMT
Fantastic post. Heres a tool that lets you build your cloud database apps without coding http://www.caspio.com/]]>lawtonterriSun, 26 Feb 2012 12:17:41 GMThttp://www.sqlmag.com/article/cloud-computing2/top-ten-free-cloud-services#commentsAnchorhttp://www.sqlmag.com/article/sql-server/reasons-virtualize-sql-server-140918#commentsAnchorTue, 21 Feb 2012 12:27:00 GMT
A couple questions here. 1. Thoughts for mission critical SQL hosted on VMware? 2. Is SQL 2008, 2012 supported on VMware? We have an SLA of 99.5 which does not include maintenance windows. We use iSCSI storage. We currently run a Windows 2003/SQL 2005 Active/Active Cluster for HA. Wanting to move to Windows2008/SQL2008 or SQL2012. I am considering vSphere5 HA/DRS. I am interested in your thoughts, since I am running iSCSI I cannot do Windows Cluster to protect the operating system. I am thinking of DB Mirroring.. ??? thank in advance. I am considering ]]>IGLOOIncTue, 21 Feb 2012 12:27:00 GMThttp://www.sqlmag.com/article/sql-server/reasons-virtualize-sql-server-140918#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2012/sql-server-2012-editions-142261#commentsAnchorMon, 13 Feb 2012 15:39:09 GMT
Is database mirroring going to be available in Standard Edition?]]>Szymon WójcikMon, 13 Feb 2012 15:39:09 GMThttp://www.sqlmag.com/article/sql-server-2012/sql-server-2012-editions-142261#commentsAnchorhttp://www.sqlmag.com/article/sqlserverdenali/case-upgrade-sql-server-denali-140166#commentsAnchorMon, 09 Jan 2012 13:04:58 GMT
In January's SQL Server Pro cover story, for which I have only partially read, Thanks 'Senior Technical Director Otey' for clearing up the meaning of "multiple databases". As I have posted on numerous MicroSoft site my reasons for utilizing their sites is One to learn and two most importantly to avoid gambling, and porn sites third so I never become a knowing and willing Pedafile or Cybercriminal. Oh so many Praises. ]]>TarantulaMon, 09 Jan 2012 13:04:58 GMThttp://www.sqlmag.com/article/sqlserverdenali/case-upgrade-sql-server-denali-140166#commentsAnchorhttp://www.sqlmag.com/article/cloud-computing2/private-cloud-faqs-141667#commentsAnchorTue, 20 Dec 2011 05:39:18 GMT
Very Good article and advice on the private cloud clearly defining what the private cloud is,adoption of the private cloud will accelerate , owing to the fact that organizations apprehensive of having sensitive data on the public cloud can adopt the private cloud and leverage the same benefits provided by the cloud.At this point also worth considering is the hybrid cloud which offers benefits of both the public and private clouds.Just watched an informative video on cloud computing,Technology benefits,providing insight into cost savings and operational efficiencies @bit.ly/uMMik3]]>AdityaJayaramTue, 20 Dec 2011 05:39:18 GMThttp://www.sqlmag.com/article/cloud-computing2/private-cloud-faqs-141667#commentsAnchorhttp://www.sqlmag.com/article/sql-server/reasons-virtualize-sql-server-140918#commentsAnchorMon, 12 Dec 2011 08:34:29 GMT
A major benefit of virtualization is related to licensing costs. More information about this and to download a "licensing calculator" visit the SQL Server Diaries blog article at http://sqlserverdiaries.com/blog/index.php/2011/11/changes-to-the-sql-server-2012-licensing-model/ ]]>anatlusMon, 12 Dec 2011 08:34:29 GMThttp://www.sqlmag.com/article/sql-server/reasons-virtualize-sql-server-140918#commentsAnchorhttp://www.sqlmag.com/article/sql-server/reasons-virtualize-sql-server-140918#commentsAnchorFri, 09 Dec 2011 12:43:19 GMT
Mike is certainly right that virtualizing SQL can save money and improve availability, but its not a solution for mission critical 7x24 applications. With many VMs running on one server in a cloud environment, a failure in the server infrastructure can be headline grabbing disaster thats why so many other failover clustering technologies, async/snyc mirroring, multiple servers and additional SW licenses and ongoing testing are needed. The cost and complexity of all this is daunting and still doesnt solve the problem. Thats why so many SQL users are turning to a far less complex and cost saving single image uptime assurance solution that prevents downtime. Mike can tell you all about it here: http://www.stratus.com/Partners/StrategicPartners/Microsoft.aspx ]]>sqluptimeFri, 09 Dec 2011 12:43:19 GMThttp://www.sqlmag.com/article/sql-server/reasons-virtualize-sql-server-140918#commentsAnchorhttp://www.sqlmag.com/article/sql-server/reasons-virtualize-sql-server-140918#commentsAnchorThu, 08 Dec 2011 17:03:16 GMT
I am a Senior BizTalk Architect and so far all the infrastructures I have designed were based on physical servers. I was a little hesitant when a client insisted in using virtual servers for a high availability architecture I designed. BizTalk is highly transaction intensive and gives SQL Server a run for its money so I was afraid the virtualization of the servers would have an adverse effect on the overall performance. Now 8 months have passed by and these servers have a performance equal to their physical counterparts. My client is confident of the stability of the architecture because now he is able to restore the VMs in jut minutes in case of a failure. Now I'm a believer!]]>iquijasThu, 08 Dec 2011 17:03:16 GMThttp://www.sqlmag.com/article/sql-server/reasons-virtualize-sql-server-140918#commentsAnchorhttp://www.sqlmag.com/article/windowsserver8/windows-server-8-140936#commentsAnchorTue, 22 Nov 2011 09:38:14 GMT
Michael, GUI is not something "to get rid of". It is a shame for Microsoft that all the people switch to GUI (iphone, ipod, ipad, android etc) while Microsoft present command line as a technical improvement.]]>murat yildirimogluTue, 22 Nov 2011 09:38:14 GMThttp://www.sqlmag.com/article/windowsserver8/windows-server-8-140936#commentsAnchorhttp://www.sqlmag.com/article/windows8/features-windows-8-141257#commentsAnchorTue, 15 Nov 2011 14:57:55 GMT
Looks great, but how about robust video and audio editing software? This is one space that Microsoft has always lacked anything worthwhile and where Apple fans have a great advantage. I would even go so far as to say the main reasons for Apple's huge successes over the last decade aside of "i" devices.]]>marcuskTue, 15 Nov 2011 14:57:55 GMThttp://www.sqlmag.com/article/windows8/features-windows-8-141257#commentsAnchorhttp://www.sqlmag.com/article/sql-server/reasons-virtualize-sql-server-140918#commentsAnchorMon, 14 Nov 2011 22:13:54 GMT
A minor correction. VMware's vSphere 5 Enterprise Plus license is based on 96 GB of RAM per VM BUT still allows Monster VMs with up to a Terabyte of RAM for a single VM without charging more that just the 96 GB license price. That provides massive Tier 1 Server Apps like SQL Server to finally be virtualized. Obviously, you may be limited to one VM on a host, but you still gain all the virtulaization benefits.]]>jweiss1113Mon, 14 Nov 2011 22:13:54 GMThttp://www.sqlmag.com/article/sql-server/reasons-virtualize-sql-server-140918#commentsAnchorhttp://www.sqlmag.com/article/windowsserver8/server-management-windows-server-8-140938#commentsAnchorWed, 19 Oct 2011 09:17:06 GMT
A major reason for Microsoft's success over the years has been it's intuitive graphical user interfaces it uses in all it's products. Microsoft's refusal to continue GUI development and forcing administrators to revert back to command line seem asinine. Becoming proficient in PowerShell is a tall order. Given the choice of learning PowerShell and learning linux, I suspect there would be a sizable group that will choose the latter.]]>mikesicWed, 19 Oct 2011 09:17:06 GMThttp://www.sqlmag.com/article/windowsserver8/server-management-windows-server-8-140938#commentsAnchorhttp://www.sqlmag.com/blog/sql-select-blog-22/sql-server-2008-r2/pass-2011-project-ldquocrescentrdquo-power-view-sql-server-2012-140887#commentsAnchorThu, 13 Oct 2011 01:40:05 GMT
hi sir...... any hint about PowerView in Sql Server 2008????]]>RohitKumarPrajapatiThu, 13 Oct 2011 01:40:05 GMThttp://www.sqlmag.com/blog/sql-select-blog-22/sql-server-2008-r2/pass-2011-project-ldquocrescentrdquo-power-view-sql-server-2012-140887#commentsAnchorhttp://www.sqlmag.com/article/sqlserverdenali/case-upgrade-sql-server-denali-140166#commentsAnchorTue, 04 Oct 2011 15:15:18 GMT
Afraid I didn't read anything here that was compelling... and that's tough because the database market continues to thrive and Microsoft needs to step up and continously improve the product line if they expect to hold onto that precious market share. ]]>Burt KingTue, 04 Oct 2011 15:15:18 GMThttp://www.sqlmag.com/article/sqlserverdenali/case-upgrade-sql-server-denali-140166#commentsAnchorhttp://www.sqlmag.com/blog/michael-oteys-blog-21/virtualization/windows-server-8-hyperv-30-evens-odds-vsphere-140573#commentsAnchorSat, 24 Sep 2011 00:30:24 GMT
Over commit has been in since sp1... Hyper-v rocks. Now these features are getting me excited. I'm not excited about metro UI... But from what I read on the storage side and this with hyper-v 3.0 I wish we could get it sooner. Teaming issues was a pain. Virtual HBA's so the wwn stays with the vm is needed. ODX will be cool if the SAN's we use now support it. HP EVA's? 4400/6400/8400? But for me the single coolest thing is live migration without shared storage. I want to move VM's between nodes that have different storage. Maybe those nodes are completely different locations. So live site has 3 dl580's with 1tb if ram and an Eva 4400 for SAN. Then my DR is a copy of that in another building. I want to be able to move a running vm from one node in bld1 to a node on building 2. Hopefully what they are talking about will let me do just that.]]>smcpartlinSat, 24 Sep 2011 00:30:24 GMThttp://www.sqlmag.com/blog/michael-oteys-blog-21/virtualization/windows-server-8-hyperv-30-evens-odds-vsphere-140573#commentsAnchorhttp://www.sqlmag.com/article/sqlserverdenali/case-upgrade-sql-server-denali-140166#commentsAnchorThu, 22 Sep 2011 18:15:56 GMT
It really does depend on how it ends up being licensed and priced. Most of the features end up only in the Enterprise edition - that gets ridiculously priced, especially when combined with WinServer. There is more and more pressure to put that money into hardware and run multiple open source DBMS servers.]]>rob_kellingtonThu, 22 Sep 2011 18:15:56 GMThttp://www.sqlmag.com/article/sqlserverdenali/case-upgrade-sql-server-denali-140166#commentsAnchorhttp://www.sqlmag.com/blog/michael-oteys-blog-21/virtualization/windows-server-8-hyperv-30-evens-odds-vsphere-140573#commentsAnchorWed, 21 Sep 2011 07:43:17 GMT
It looks like Hyper-V is really coming along. What about over commitment for memory and processors? This is one feature that we leverage vSphere for and has really helped improve server consolidation.]]>ESWed, 21 Sep 2011 07:43:17 GMThttp://www.sqlmag.com/blog/michael-oteys-blog-21/virtualization/windows-server-8-hyperv-30-evens-odds-vsphere-140573#commentsAnchorhttp://www.sqlmag.com/blog/michael-oteys-blog-21/virtualization/windows-server-8-hyperv-30-evens-odds-vsphere-140573#commentsAnchorWed, 14 Sep 2011 23:08:09 GMT
Hi Michael Interesting additions to the feature set of Hyper V. Any release date for such a massive feature set? My concern is how stable they will be initially, as it is one thing to say yes we will do these features but another to actually delvier on the promise. Time will tell. Any mentions of changes to backups within a Hyper V environment? Anything similar to the VMware VADP functionality? Thanks David]]>dmanconiWed, 14 Sep 2011 23:08:09 GMThttp://www.sqlmag.com/blog/michael-oteys-blog-21/virtualization/windows-server-8-hyperv-30-evens-odds-vsphere-140573#commentsAnchorhttp://www.sqlmag.com/blog/michael-oteys-blog-21/virtualization/views-vmworld-vmware-takes-aim-smb-virtualization-140422#commentsAnchorThu, 01 Sep 2011 03:22:13 GMT
It is pleasure a going through your post. I have bookmarked you to check out new stuff from your side. Seo New York (NYC) ]]>zoesmithThu, 01 Sep 2011 03:22:13 GMThttp://www.sqlmag.com/blog/michael-oteys-blog-21/virtualization/views-vmworld-vmware-takes-aim-smb-virtualization-140422#commentsAnchorhttp://www.sqlmag.com/article/VisualStudioLightSwitch/visual-studio-lightswitchs-target-audience-136433#commentsAnchorFri, 12 Aug 2011 17:53:44 GMT
I forgot to add 2 things. 1. Full Disclosure: I work at Microsoft Research. But these opinions are my own. They may be skewed by the fact that I didn't have to pay anything for Visual Studio or Lightswitch in order to try them out. 2. Thanks for introducing me to it. The first I ever heard of this tool was in your SQL Server Magazine article. ]]>JimJerniganFri, 12 Aug 2011 17:53:44 GMThttp://www.sqlmag.com/article/VisualStudioLightSwitch/visual-studio-lightswitchs-target-audience-136433#commentsAnchorhttp://www.sqlmag.com/article/VisualStudioLightSwitch/visual-studio-lightswitchs-target-audience-136433#commentsAnchorFri, 12 Aug 2011 17:48:22 GMT
The target audience for Lightswitch must be me. I am a SysAdmin and entry-level DBA. I have been begging our developers for tools to let me manage our data, but admin tools always fall to the bottom of the priority list and never get created. They figure, if they give us a half-way functional Access front end, and the ability to just edit tables directly with SSMS, why do we need admin tools? Well - I just learned Lightswitch in 1 hour and in 2 more hours I had a fully functional app, hosted on IIS, to manage our data. And I don't know the first thing about C#. I will be recommending this tool to all the SysAdmin/SysEngineer types I know. We're not exactly end users, but we will know what to do with this and will get immediate value out of it. If you haven't already, you should do a full article for the main publication, Windows IT Pro. Even if they are not the intended target audience for Lightswitch, they will love it. ]]>JimJerniganFri, 12 Aug 2011 17:48:22 GMThttp://www.sqlmag.com/article/VisualStudioLightSwitch/visual-studio-lightswitchs-target-audience-136433#commentsAnchorhttp://www.sqlmag.com/blog/project-plan-dbadmin-sql-server-2008-r2-79/sql-select-blog-22/sql-server-2008-r2/overview-sql-server-high-availability-options-140053#commentsAnchorThu, 04 Aug 2011 15:28:12 GMT
It would seem that Microsoft considers Replication as a MS SQL High Availability option as well.]]>razmusThu, 04 Aug 2011 15:28:12 GMThttp://www.sqlmag.com/blog/project-plan-dbadmin-sql-server-2008-r2-79/sql-select-blog-22/sql-server-2008-r2/overview-sql-server-high-availability-options-140053#commentsAnchorhttp://www.sqlmag.com/article/VisualStudioLightSwitch/visual-studio-lightswitchs-target-audience-136433#commentsAnchorThu, 04 Aug 2011 11:45:00 GMT
Although your users or your thoughts of users are as stated, that they know nothing about what applications are or what goes into making themlet alone knowing how to build one themselves, is simply not true in some cases/companies. I have been in IT since 1984 and if there is one thing I have learned is that users (grant you some users) do know what an application is and what goes into developing one. And having end-users that has these skills may make my and your job easier and benefit the company. There is nothing wrong with providing the end-users with tools that let's them design what they might need to complete a project. And I welcome the fact that this might relieve me of developing custom applications for that end-user. And letting users know that you consider them to be lacking in knowledge will bit you in the end... ]]>BetterCallTyroneThu, 04 Aug 2011 11:45:00 GMThttp://www.sqlmag.com/article/VisualStudioLightSwitch/visual-studio-lightswitchs-target-audience-136433#commentsAnchorhttp://www.sqlmag.com/blog/project-plan-dbadmin-sql-server-2008-r2-79/sql-select-blog-22/sql-server-2008-r2/overview-sql-server-high-availability-options-140053#commentsAnchorWed, 03 Aug 2011 16:04:31 GMT
There are 3 operating modes of mirroring. High safety with automatic failover which requires a witness server High safety without automatic failover, which does not require a witness server High Performance mode. High Performance mode is the one that requires the Enterprise edition of SQL Server, not the High Safety mode. Best. M.S]]>michael s.Wed, 03 Aug 2011 16:04:31 GMThttp://www.sqlmag.com/blog/project-plan-dbadmin-sql-server-2008-r2-79/sql-select-blog-22/sql-server-2008-r2/overview-sql-server-high-availability-options-140053#commentsAnchorhttp://www.sqlmag.com/article/product-review/hyper-v-r2-vs-esx-server-136306#commentsAnchorWed, 27 Jul 2011 10:44:21 GMT
Michael, I need to challenge you about your comment regarding licensing "This licensing applies to any type of virtualization platform, including ESX Server". If I read Microsoft's FAQ's correctly, this is not a true statement. It seems that for this model to apply, Windows must be installed on the physical hardware. This would mean that you would be running Hyper-V as the Hypervisor and not VMware. http://www.microsoft.com/windowsserver2008/en/us/licensing-faq.aspx#virt Can you comment on the source of this information? ]]>NagorgWed, 27 Jul 2011 10:44:21 GMThttp://www.sqlmag.com/article/product-review/hyper-v-r2-vs-esx-server-136306#commentsAnchorhttp://www.sqlmag.com/article/vbscript/10-more-vbscript-techniques#commentsAnchorFri, 15 Jul 2011 09:53:41 GMT
Thanks]]>Fri, 15 Jul 2011 09:53:41 GMThttp://www.sqlmag.com/article/vbscript/10-more-vbscript-techniques#commentsAnchorhttp://www.sqlmag.com/article/VisualStudioLightSwitch/visual-studio-lightswitchs-target-audience-136433#commentsAnchorWed, 13 Jul 2011 10:00:13 GMT
I have sometimes wondered why Access isnt re-written using a combination of currently "in" tools such an SQL Server back-end, VB.NET / ASP.NET web and windows forms front-end, and report-builder or some such thing for reporting....It would be convenient if all these things can be packaged together, the way stuff is combined in an Access file today!]]>chaitanya.dabholkarWed, 13 Jul 2011 10:00:13 GMThttp://www.sqlmag.com/article/VisualStudioLightSwitch/visual-studio-lightswitchs-target-audience-136433#commentsAnchorhttp://www.sqlmag.com/article/cloud-computing2/cloud-proof-career-136168#commentsAnchorFri, 01 Jul 2011 10:22:03 GMT
Keep in mind what industries will AND which CANNOT use the cloud. Defense and Intelligence agencies and supporting industries will not leverage the commercial cloud. Data is too sensitive for that. I can see marketing sites on the cloud. Most government agencies at all levels can leverage the cloud but I can see internal politics muddying that. There are definite viable uses for the cloud especially for general purpose public facing sites like dispensing forms and brochures. For sensitive data, which is much of the enterprise's data, in my opinion, will not and should not be on the cloud. Customer and employee PII should not be on the cloud. Enterprises should keep that in their pocket where it is most safe. Therefore, DBAs, SAs, NA, Storage Admins and the such, will only lose a trivial portion of their work. Lots of it they will be glad to keep beyond the DMZ. There's more important systems to maintain ;-)]]>RickFri, 01 Jul 2011 10:22:03 GMThttp://www.sqlmag.com/article/cloud-computing2/cloud-proof-career-136168#commentsAnchorhttp://www.sqlmag.com/article/cloud-computing2/virtualization-cloud-mobility-driving-evolution-139514#commentsAnchorFri, 17 Jun 2011 14:41:28 GMT
With virtualization now a core infrastructure platform, ensuring performance and quality of service is of vital importance. With virtualized systems sharing a common physical host and disk I/O still being the primary bottleneck on physical hosts, companies are looking for tools to maximize I/O throughput in their virtual environments. Studies show that even in virtual environments, file and free space fragmentation can negatively impact performance - causing I/O bottlenecks and inefficiencies in the hypervisor. Studies have shown that optimization of virtual guests results in decreased number of IOPS, larger I/O sizes, decreases in I/O latency and a larger number of sequential I/Os. While optimization of virtual guests results in performance improvements, care must be taken to ensure that optimization itself doesn't negatively impact performance across the virtual environment. The ability for a guest optimization tool to run and not impact performance on the physical host or other guests is absolutely key to selecting an optimization solution. The ability to work with "zero-detect" storage solutions for recovery of over-allocated disk space is also desirable. Lauren @RaxcoSoftware www.PerfectDisk.com]]>LaurenFri, 17 Jun 2011 14:41:28 GMThttp://www.sqlmag.com/article/cloud-computing2/virtualization-cloud-mobility-driving-evolution-139514#commentsAnchorhttp://www.sqlmag.com/article/Office-365/top-ten-features-office-365-136405#commentsAnchorThu, 16 Jun 2011 09:51:48 GMT
While I like this site and Michael, I would make some corrections here... starting with 1) External User Access Ease 2) Anonymous Access for 365 (non-enterprise) 3) Email - BPOS and 365 email are so close to client feature parity and it is making even the install of the client almost irrelevant 4) Modular deployment of functionality AKA Sandbox - while most users will never even know what this means for them, it will have a "similar" effect to that of the "App Store" 5)Premise to Cloud integration - for those "old timers" who like to look at their servers and do not yet believe in the cloud this is a big deal. Effectively, 365 web apps or Live web apps destroys and sticks the dagger in Google "docs" - they work on iphone / ipad for goodness sake. Google has a cool integration iphone / ipad app but in time someone will create this for the 365 platform as well. Bert Blevins]]>bertkashThu, 16 Jun 2011 09:51:48 GMThttp://www.sqlmag.com/article/Office-365/top-ten-features-office-365-136405#commentsAnchorhttp://www.sqlmag.com/article/configuration/key-sql-azure-database-differences#commentsAnchorTue, 17 May 2011 04:56:28 GMT
this information is false the link you put to msdn reference is saying the opposite u say not support image ,ntext,spatil datatypes no it supports the all and review the link : http://msdn.microsoft.com/en-us/library/ee336233.aspx]]>Mostafa sabriTue, 17 May 2011 04:56:28 GMThttp://www.sqlmag.com/article/configuration/key-sql-azure-database-differences#commentsAnchorhttp://www.sqlmag.com/article/cloud-computing2/is-the-cloud-really-just-the-return-of-mainframe-computing--129854#commentsAnchorThu, 12 May 2011 22:22:53 GMT
Sucessful database cloud computing requires separation of a business data model from data repository. To be more clear, business logic belongs to business and current database structure/model does not give us an option to separate of data repository and business logic (represented through data model). A data model is the key between the data peaces and usefull information. If a cloud vendor can provide "universal data model" in the cloud, I will be able to adapt my business data model in such a wey to be able to perform business transactions using pointers to data that exists within the cloud. In this case a DBA will have confidence to accept cloud as a data container for big enterprise databases. Cloud vendors do not offer enough in regards to database in cloud. I’ll rather create my local cloud in current case. ]]>stocklanditThu, 12 May 2011 22:22:53 GMThttp://www.sqlmag.com/article/cloud-computing2/is-the-cloud-really-just-the-return-of-mainframe-computing--129854#commentsAnchorhttp://www.sqlmag.com/article/cloud-computing2/is-the-cloud-really-just-the-return-of-mainframe-computing--129854#commentsAnchorThu, 12 May 2011 16:30:57 GMT
Yeah there will be lots of functionality that distinguish the cloud from the mainframe model. But that doesn’t negate the main reason the major ISV’s are dying for the world to adopt the cloud. They want businesses and individuals to pay monthly subscriptions forever. In the 90’s they called it the ASP model (application service provider) only the bandwidth wasn’t ready then. Now it is. There is no perfect model this one will have its warts too. Stay tuned]]>mfritz2020Thu, 12 May 2011 16:30:57 GMThttp://www.sqlmag.com/article/cloud-computing2/is-the-cloud-really-just-the-return-of-mainframe-computing--129854#commentsAnchorhttp://www.sqlmag.com/article/cloud-computing2/is-the-cloud-really-just-the-return-of-mainframe-computing--129854#commentsAnchorThu, 12 May 2011 15:43:14 GMT
Simple personal reasons why to love the cloud * hardware fails. Having gone through 3 laptops and migrated before to Google was a total change. From my "puppy died" emotion when my first harddisc failed to who cares, I have my data in the cloud. * realtime sync of data to the cloud and important stuff back to several PC-s- when another laptop harddisk failed, first time ever everything was backed up, so just new gadget and sync from the cloud * VMware making conf-s just another file/folder that can be synced and run everywhere where I want. So, it’s not just some strange app where the user is powerless. (run in your single provider or don’t run) For individual user it’s a myriad of alternatives to choose what you want to keep where and what machine to run where.]]>BaldurThu, 12 May 2011 15:43:14 GMThttp://www.sqlmag.com/article/cloud-computing2/is-the-cloud-really-just-the-return-of-mainframe-computing--129854#commentsAnchorhttp://www.sqlmag.com/article/cloud-computing2/is-the-cloud-really-just-the-return-of-mainframe-computing--129854#commentsAnchorThu, 12 May 2011 15:24:51 GMT
Good article. It’s very strange to want to use ever more powerful PCs as dumb workstations. The cloud should extend to all computing devices. This is explained in this e-booklet: http://www.amazon.com/The-Ether-ebook/dp/B004HO68WY/ref=sr_1_1?ie=UTF8&m=AG56TWVU5XWC2&s=digital-text&qid=1305231822&sr=1-1 ]]>gudmkThu, 12 May 2011 15:24:51 GMThttp://www.sqlmag.com/article/cloud-computing2/is-the-cloud-really-just-the-return-of-mainframe-computing--129854#commentsAnchorhttp://www.sqlmag.com/article/dhcp2/network-configuration-tasks-with-netsh#commentsAnchorSun, 08 May 2011 12:11:47 GMT
I am trying to get lease info and can’t get the show lease switch to work on windows 2003 server, as in - netsh dhcp server show lease Actual help documentation doesn’t show anything about "show lease." ]]>userabcSun, 08 May 2011 12:11:47 GMThttp://www.sqlmag.com/article/dhcp2/network-configuration-tasks-with-netsh#commentsAnchorhttp://www.sqlmag.com/article/project-plan-virtualization-sql-server-2008-r2-89/sql-server/7-practices-running-sql-server-hyperv-135931#commentsAnchorTue, 26 Apr 2011 12:47:09 GMT
Hi Michael, to your #6: There is no need to waste disk space by using fixed VHDs to get better IO performance. http://virsto.com/blog/posts/want-your-virtual-environment-to-perform-spend-more-money-on-storage]]>Mark DavisTue, 26 Apr 2011 12:47:09 GMThttp://www.sqlmag.com/article/project-plan-virtualization-sql-server-2008-r2-89/sql-server/7-practices-running-sql-server-hyperv-135931#commentsAnchorhttp://www.sqlmag.com/article/project-plan-planning-sql-server-2008-r2-75/sql-server/sql-server-version-build-numbers#commentsAnchorFri, 15 Apr 2011 07:30:38 GMT
SELECT @@VERSION gives you all that info and more, including the version of Windows you’re running under: Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) ]]>daveFri, 15 Apr 2011 07:30:38 GMThttp://www.sqlmag.com/article/project-plan-planning-sql-server-2008-r2-75/sql-server/sql-server-version-build-numbers#commentsAnchorhttp://www.sqlmag.com/article/project-plan-planning-sql-server-2008-r2-75/sql-server/sql-server-version-build-numbers#commentsAnchorFri, 15 Apr 2011 02:59:25 GMT
Here’s a very good page with full version list http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx]]>NecmettinFri, 15 Apr 2011 02:59:25 GMThttp://www.sqlmag.com/article/project-plan-planning-sql-server-2008-r2-75/sql-server/sql-server-version-build-numbers#commentsAnchorhttp://www.sqlmag.com/article/project-plan-planning-sql-server-2008-r2-75/sql-server/sql-server-version-build-numbers#commentsAnchorFri, 15 Apr 2011 02:12:15 GMT
Wouldn’t SELECT @@version give similar results? ]]>bjornFri, 15 Apr 2011 02:12:15 GMThttp://www.sqlmag.com/article/project-plan-planning-sql-server-2008-r2-75/sql-server/sql-server-version-build-numbers#commentsAnchorhttp://www.sqlmag.com/article/cloud-computing2/is-the-cloud-really-just-the-return-of-mainframe-computing--129854#commentsAnchorThu, 14 Apr 2011 18:33:56 GMT
"Small correction: bell bottoms were a ’70s thing" Well, they started in the late ’60s. I got my bachelor’s degree in ’70, and they were already "the thing" well before I started that senior year (in 1969).]]>billiken66Thu, 14 Apr 2011 18:33:56 GMThttp://www.sqlmag.com/article/cloud-computing2/is-the-cloud-really-just-the-return-of-mainframe-computing--129854#commentsAnchorhttp://www.sqlmag.com/article/project-plan-planning-sql-server-2008-r2-75/sql-server/sql-server-version-build-numbers#commentsAnchorThu, 14 Apr 2011 16:20:11 GMT
Here’s a page with a more complete list that I’ve found very helpful: http://sqlserverbuilds.blogspot.com/ ]]>kbrenemanThu, 14 Apr 2011 16:20:11 GMThttp://www.sqlmag.com/article/project-plan-planning-sql-server-2008-r2-75/sql-server/sql-server-version-build-numbers#commentsAnchorhttp://www.sqlmag.com/article/project-plan-planning-sql-server-2008-r2-75/sql-server/sql-server-version-build-numbers#commentsAnchorTue, 05 Apr 2011 07:43:21 GMT
What about the SQL Server 2008 and SQL Server 2008 R2 SPs? Thanks, TRente]]>Tiago RenteTue, 05 Apr 2011 07:43:21 GMThttp://www.sqlmag.com/article/project-plan-planning-sql-server-2008-r2-75/sql-server/sql-server-version-build-numbers#commentsAnchorhttp://www.sqlmag.com/article/business-intelligence/review-hp-business-decision-appliance-129569#commentsAnchorWed, 30 Mar 2011 09:15:41 GMT
A wonderful piece of a device.Thanks very much for the review it is very much appreciated.]]>JonesWed, 30 Mar 2011 09:15:41 GMThttp://www.sqlmag.com/article/business-intelligence/review-hp-business-decision-appliance-129569#commentsAnchorhttp://www.sqlmag.com/article/cloud-computing2/is-the-cloud-really-just-the-return-of-mainframe-computing--129854#commentsAnchorThu, 24 Mar 2011 18:33:41 GMT
Small correction: bell bottoms were a ’70s thing - think Donny Osmond. Otherwise I reckon this is pretty much on the money.]]>PriestThu, 24 Mar 2011 18:33:41 GMThttp://www.sqlmag.com/article/cloud-computing2/is-the-cloud-really-just-the-return-of-mainframe-computing--129854#commentsAnchorhttp://www.sqlmag.com/article/high-availability/the-price-high-availability#commentsAnchorThu, 17 Mar 2011 01:10:40 GMT
Marathon Technologies www.marathontechnologies.com provides Stratus and NEC ftServer like availability through software lockstepping of CPUs, memory and disks. So you get true full fault-tolerance with no downtime as opposed to the stratus avance software and ftServer (proprietary hardware).]]>jasonawThu, 17 Mar 2011 01:10:40 GMThttp://www.sqlmag.com/article/high-availability/the-price-high-availability#commentsAnchorhttp://www.sqlmag.com/article/cloud-computing2/top-ten-free-cloud-services#commentsAnchorWed, 16 Mar 2011 15:29:11 GMT
@Stallings - I have no problem storing all sorts of files in my SkyDrive. I’ve put PDFs, ZIPs, RARs, and a few MP3s in there without issue. Live Mesh is run on your workstation, be that a laptop or desktop, and has nothing to do with the core SkyDrive service.]]>RellerWed, 16 Mar 2011 15:29:11 GMThttp://www.sqlmag.com/article/cloud-computing2/top-ten-free-cloud-services#commentsAnchorhttp://www.sqlmag.com/article/cloud-computing2/top-ten-free-cloud-services#commentsAnchorThu, 10 Mar 2011 00:50:56 GMT
Regarding Windows Live SkyDrive, you state that "The only requirement for using SkyDrive is that you have a Windows Live account". My last check of SkyDrive found that it consists of two parts: Windows Live Skydrive and Windows Live Mesh. Mesh has access to 5 GB of SkyDrive, is referred to as SkyDrive Sync, and will accept most file formats. Live SkyDrive has access to 20 GB, but will only accept Microsoft Office documents (i.e., Word, Excel, PowerPoint, etc) and a few graphics formats. These limitations impose further requirement on the uses of SkyDrive.]]>StallingsThu, 10 Mar 2011 00:50:56 GMThttp://www.sqlmag.com/article/cloud-computing2/top-ten-free-cloud-services#commentsAnchorhttp://www.sqlmag.com/article/sql-server/the-great-sql-server-migration-question#commentsAnchorTue, 01 Mar 2011 07:29:50 GMT
I work for one of the five largest banks in the US, and even with all the resources at our disposal we cannot keep up with this release cycle. Most of our environment is still on SQL 2005, and as of now have no plans to upgrade any of them to SQL 2008. Most of the projects we support are implemented on the most current version of of SQL (i.e. SQL 2008), and then are never upgraded. That’s because most of these projects are decommissioned before we ever get to the end of life of the SQL version. However, when we do have to upgrade, we generally only upgrade one version; for example, upgrading an old system from SQL 2000 to 2005. This is because the development team can spend the smallest amount of coding time to keep the project on a supported version of SQL. I think Microsoft should keep SQL Server on a 5 year cycle for major upgrades. SQL is a major core product for any project, and it cannot be upgraded at this rate.]]>KeislerTue, 01 Mar 2011 07:29:50 GMThttp://www.sqlmag.com/article/sql-server/the-great-sql-server-migration-question#commentsAnchorhttp://www.sqlmag.com/blog/michael-oteys-blog-21/news2/microsoft-and-hp-release-new-bi-appliances-136959#commentsAnchorSat, 26 Feb 2011 05:26:15 GMT
SEO London Search Engine Optimisation London, Google SEO, PPC. The London SEO company (Seobaba ) that puts you on first page of search engines.]]>brianhookSat, 26 Feb 2011 05:26:15 GMThttp://www.sqlmag.com/blog/michael-oteys-blog-21/news2/microsoft-and-hp-release-new-bi-appliances-136959#commentsAnchorhttp://www.sqlmag.com/blog/michael-oteys-blog-21/news2/microsoft-and-hp-release-new-bi-appliances-136959#commentsAnchorSat, 26 Feb 2011 05:26:06 GMT
Do You Want Your Web Site To Bring You in the top ten rankings then contact SEOBaba UK]]>brianhookSat, 26 Feb 2011 05:26:06 GMThttp://www.sqlmag.com/blog/michael-oteys-blog-21/news2/microsoft-and-hp-release-new-bi-appliances-136959#commentsAnchorhttp://www.sqlmag.com/article/sql-server/the-great-sql-server-migration-question#commentsAnchorFri, 18 Feb 2011 10:42:07 GMT
We deployed SS 2008 R2 mainly because we are setting up a Sharepoint 2010 environment and we thiught that we might use PowerPivot. I also deployed it to a monitoring server because I could. As manu have said previously, vendor support drives this for us most of the time and they are slow to support new versions.]]>HottleFri, 18 Feb 2011 10:42:07 GMThttp://www.sqlmag.com/article/sql-server/the-great-sql-server-migration-question#commentsAnchorhttp://www.sqlmag.com/article/sql-server/the-great-sql-server-migration-question#commentsAnchorThu, 17 Feb 2011 20:06:57 GMT
Your database environment is not like Office products. This is the engine of your business usually and swapping out a well running engine or an engine in which you know the limitations of for an unknown engine is scary for businesses because ironing out the bugs could be a loss of revenue for businesses ironing out the issues.

They seriously need to look at SQL Server as a business application instead of something to make a buck off of quickly. Buggy databases could easily make another DBMS an option when SQL Server was the preferred solution.....]]>FranklinThu, 17 Feb 2011 20:06:57 GMThttp://www.sqlmag.com/article/sql-server/the-great-sql-server-migration-question#commentsAnchorhttp://www.sqlmag.com/article/sql-server/the-great-sql-server-migration-question#commentsAnchorThu, 17 Feb 2011 13:58:07 GMT
The idea that a company needs to keep up with every latest release is ludicrous. It has never been a part of our plans and never will. A company should make decisions and take actions based on what is best for the company and the customers they support.

When we found out that MS was going to release Sql Server 2008 and then Sql Server 2008 R2 we did not feel any pressure to upgrade. We had just upgraded to Sql Server 2005 in 2007.

We decided that unless we found out that there was a compelling reason to upgrade (hasn’t happened yet.) that we would skip a full release iteration and go with the next full release of Sql Server. In our world the release of Sql Server Code Named "Denali", will be right on time.

Have a great day.]]>DawsonThu, 17 Feb 2011 13:58:07 GMThttp://www.sqlmag.com/article/sql-server/the-great-sql-server-migration-question#commentsAnchorhttp://www.sqlmag.com/article/sql-server/the-great-sql-server-migration-question#commentsAnchorThu, 17 Feb 2011 13:38:55 GMT
SQL 2005 moving to SQL 2008 R2.

I completely understand being tied to one’s vendors and the database versions they support. Who moves to a database version that their vendor clearly states "We don’t support that"? No one.


On the other hand I worked at a large travel and leisure company where deferred maintenance had been the order of the day for too many years and it was impacting their ability to stay competitive. There mindset of staying in the past wasn’t driven by the absence of vendor support but by IT execs wanting to keep expenses down and that EOY bonus up.

]]>John LangstonThu, 17 Feb 2011 13:38:55 GMThttp://www.sqlmag.com/article/sql-server/the-great-sql-server-migration-question#commentsAnchorhttp://www.sqlmag.com/article/sql-server/the-great-sql-server-migration-question#commentsAnchorThu, 17 Feb 2011 12:24:05 GMT
A huge part of the problem, in my opinion, is the vendors that we buy from. I don’t have a single vendor, other than MS, that can support 2008. I am in process of getting rid of my last 7 hold out. Still have 2000 and those won’t be going away for another year at least. SLOW DOWN! The few things I write internally will work on 2008 R2 but since my vendors are on 2005, why buy another SQL server for a few internal apps.

Again, SLOW DOWN!

We cannot afford it and the vendors cannot support so many changes. A new release every 4 years should be good enough. Plus I cannot afford to continually pay to upgrade my skill set via training every 10 minutes!]]>TOWNSENDThu, 17 Feb 2011 12:24:05 GMThttp://www.sqlmag.com/article/sql-server/the-great-sql-server-migration-question#commentsAnchorhttp://www.sqlmag.com/article/free-tools/top-10-free-tools-for-managing-windows#commentsAnchorMon, 14 Feb 2011 04:58:43 GMT
Nice list! WinDirStat used to be one of my favorites, but I replaced it with JDiskReport (http://www.jgoodies.com/freeware/jdiskreport/). WinDirStat won’t even see directories once the path it’s looking in gets beyond a certain depth, but JDiskReport sees (and shows) everything. I know because I was dealing with a directory structure a few months ago that had paths 20 or 30 directories deep that I knew had over 30 GB in it. WinDirStat would only show me a total size of 20 GB, but JDiskReport showed me a total size of 35 GB.]]>Jonathan PMon, 14 Feb 2011 04:58:43 GMThttp://www.sqlmag.com/article/free-tools/top-10-free-tools-for-managing-windows#commentsAnchorhttp://www.sqlmag.com/article/high-availability/the-price-high-availability#commentsAnchorTue, 08 Feb 2011 16:16:35 GMT
This is right on, plus the higher license fees, witness servers and general "overprovisioning of servers" for performance add more costs to consider. For smaller companies looking at traditional failover clustering, lower price software HA products like Stratus Avance that run on industry standard HW are as big as it gets for an IT "no brainer" for SQL administrators.]]>sqluptimeTue, 08 Feb 2011 16:16:35 GMThttp://www.sqlmag.com/article/high-availability/the-price-high-availability#commentsAnchorhttp://www.sqlmag.com/article/high-availability/the-price-high-availability#commentsAnchorMon, 07 Feb 2011 22:33:11 GMT
Judging from paypal case, I realize now that high availability becomes very important for mission critical systems.

Thanks for raising me awareness how important to keep data available in possibility of disaster might happen at any point of time.]]>wiramaMon, 07 Feb 2011 22:33:11 GMThttp://www.sqlmag.com/article/high-availability/the-price-high-availability#commentsAnchorhttp://www.sqlmag.com/article/sql-server/the-great-sql-server-migration-question#commentsAnchorThu, 20 Jan 2011 07:26:47 GMT
Who says anyone needs to keep up with the latest release? How can Microsoft possibly anticipate every customer’s acceptance rate? As long as Microsoft is clear about what is new and/or improved in each release, customers should be smart enough to decide when they are ready to upgrade. The real keys are:
* Ensuring every release includes some number of the most asked for core database engine improvements and extensions - sometimes it seems MS forgets about db admins in the push to grow market share through whole new technologies geared toward developers and executives
* Maintaining a support cycle that does not force customers into upgrades prematurely
* Keeping the needs and limitations of small/medium businesses in mind, not just the big boys. This has more to do with features and price than release cycles, but I would like MS to consider a more granular approach to product packaging. Many organizations need a relatively small subset of the features in Enterprise Edition that are not available in Standard Edition. The ability to purchase only what you need would be a significant step in the right direction.]]>RandallThu, 20 Jan 2011 07:26:47 GMThttp://www.sqlmag.com/article/sql-server/the-great-sql-server-migration-question#commentsAnchorhttp://www.sqlmag.com/blog/michael-oteys-blog-21/news2/microsoft-and-hp-release-new-bi-appliances-136959#commentsAnchorThu, 20 Jan 2011 03:40:18 GMT
Thanks for writing in such an encouraging post. I had a glimpse of it and couldn’t stop reading till I
finished.

Seo Agency india

Seo Agency India
]]>jack495Thu, 20 Jan 2011 03:40:18 GMThttp://www.sqlmag.com/blog/michael-oteys-blog-21/news2/microsoft-and-hp-release-new-bi-appliances-136959#commentsAnchorhttp://www.sqlmag.com/article/sql-server/the-great-sql-server-migration-question#commentsAnchorWed, 12 Jan 2011 14:43:02 GMT
your article on will the cloud kill virtualazation is very insightful.. as you may have found out i am no closer to being a programmer than i am to piloting the next space shuttle, despite i am data mining yet first i must finish comprehending ’Bayesian Algorithms’ your peer ~ Tarantula ~ {~!~} ’.’ ]]>DaggersWed, 12 Jan 2011 14:43:02 GMThttp://www.sqlmag.com/article/sql-server/the-great-sql-server-migration-question#commentsAnchorhttp://www.sqlmag.com/blog/michael-oteys-blog-21/news2/nec-express5800r320a-fault-tolerant-server-136955#commentsAnchorFri, 24 Dec 2010 06:11:11 GMT
Thanks for writing in such an encouraging post. I had a glimpse of it and couldn’t stop reading till I finished.

http://www.healthmantra.co.uk/detox_cleanse/madal_bal_natural_tree_syrup_lemon_detox_diet_1_ltr_cayenne
Madal BAL Natural tree syrup
]]>Madal Bal Natural Tree Syrup, when mixed with the Fri, 24 Dec 2010 06:11:11 GMThttp://www.sqlmag.com/blog/michael-oteys-blog-21/news2/nec-express5800r320a-fault-tolerant-server-136955#commentsAnchorhttp://www.sqlmag.com/article/VisualStudioLightSwitch/Turning-On-To-LightSwitch-126007#commentsAnchorTue, 23 Nov 2010 09:37:35 GMT
Lightswitch looks like a great way to expose basic data to users without having to jump through the hoops of c#. I’ve followed the basic tutorials on the beta; are there more in depth discussions of the product? Specifically I would like to understand how the data is accessed for existing db’s, the turorials I’ve seen are all about creating sql express db’s. I have a need for simple inquiries and updates against one or two tables in a db and this would be perfect for that.]]>OLSENTue, 23 Nov 2010 09:37:35 GMThttp://www.sqlmag.com/article/VisualStudioLightSwitch/Turning-On-To-LightSwitch-126007#commentsAnchorhttp://www.sqlmag.com/article/virtualization2/will-the-cloud-kill-virtualization-#commentsAnchorThu, 18 Nov 2010 15:44:51 GMT
You do a nice job describing the evolution of virtualization and contrasting Microsoft and VMWare! It seems to me though, that Microsoft is more about choice than one technology killing another. If anything, this is their weakness as a company (compare to Apple). As for cloud, they have a very long way to go. They are still shifting from BPOS to Office 365, for example and very few partners are selling cloud services. Even when Microsoft is ready for prime time, there will always be trade-offs in deployment models. So, while I agree with your conclusion, I am not sure that Microsoft really believes that the cloud will kill on-premise virtualization. Here is a simple blog article that I wrote highlighting some of the issues that customers are facing today with cloud deployments:

http://www.turbotekcomputer.com/resources/small-business-it-blog/bid/47785/Cloud-Computing-Virus-Protection-Software-and-Malware

While it does not focus specifically on virtualization, the same issues of control come into play and I think that Microsoft understands this. They are much more afraid of Google than they are interested in cannibalizing Hyper-V and VMWare. ]]>Sean KlineThu, 18 Nov 2010 15:44:51 GMThttp://www.sqlmag.com/article/virtualization2/will-the-cloud-kill-virtualization-#commentsAnchorhttp://www.sqlmag.com/article/windows-server/top-10-remote-desktop-keyboard-shortcuts#commentsAnchorWed, 17 Nov 2010 04:15:19 GMT
So Alt+Delete is like Alt+Space?]]>Michel de RuiterWed, 17 Nov 2010 04:15:19 GMThttp://www.sqlmag.com/article/windows-server/top-10-remote-desktop-keyboard-shortcuts#commentsAnchorhttp://www.sqlmag.com/article/sql-server/7-easy-asp-net-techniques#commentsAnchorFri, 12 Nov 2010 07:32:12 GMT
Nice article, but I do wonder if it is in the wrong magazine. I would prefer SQL here or perhaps some .NET with at least a passing reference to SQL.

Thanks
Ian
]]>stirkFri, 12 Nov 2010 07:32:12 GMThttp://www.sqlmag.com/article/sql-server/7-easy-asp-net-techniques#commentsAnchorhttp://www.sqlmag.com/article/mobile-computing-devices/top-10-windows-phone-7-enterprise-features#commentsAnchorThu, 11 Nov 2010 21:24:13 GMT
Johnson: Some phones (my Samsung Focus for example) do allow SD cards: I have 40GB of RAM in mine. Large enterprises absolutely are concerned with removable media as a data leak risk. The difference with WinPhone7 is that the added storage is bound to the phone and can’t be removed and just popped into another computer for data mining.

Kennington: Have you actually PLAYED with the WinPhone7? It’s absolutely a consumer device FIRST. Zune, XBox, and stunning apps (the best mobile version of Facebook on any platform) and completely integrated experiences... this is consumer FIRST which is probably why it helps to point out that there are some compelling enterprise features also.

and Priest, the point is managed code... that’s a big win over the chaos that is iOS.]]>HolmeThu, 11 Nov 2010 21:24:13 GMThttp://www.sqlmag.com/article/mobile-computing-devices/top-10-windows-phone-7-enterprise-features#commentsAnchorhttp://www.sqlmag.com/article/mobile-computing-devices/top-10-windows-phone-7-enterprise-features#commentsAnchorThu, 11 Nov 2010 18:09:30 GMT
I’m with Kennington. What is the value to no SD card to the "Enterprise"? Maybe our Enterprise needs more storage space on its phones! Allow this to be turned on/off through policy like USB on PCs, and you have an Enterprise feature. I was strongly considering a Win7 phone, but without SD, I believe I’ll pass.]]>JohnsonThu, 11 Nov 2010 18:09:30 GMThttp://www.sqlmag.com/article/mobile-computing-devices/top-10-windows-phone-7-enterprise-features#commentsAnchorhttp://www.sqlmag.com/article/VisualStudioLightSwitch/Turning-On-To-LightSwitch-126007#commentsAnchorMon, 08 Nov 2010 12:42:44 GMT
Will it be possible to load Apps generated by LightSwitch into Visual Studio (Express) for further development???.

Thx

PD: sorry about the question marks!!]]>WoodstopMon, 08 Nov 2010 12:42:44 GMThttp://www.sqlmag.com/article/VisualStudioLightSwitch/Turning-On-To-LightSwitch-126007#commentsAnchorhttp://www.sqlmag.com/article/VisualStudioLightSwitch/Turning-On-To-LightSwitch-126007#commentsAnchorMon, 08 Nov 2010 12:41:39 GMT
Will it be possible to load Apps generated by LightSwitch into Visual Studio (Express) for further development.

Thx.]]>WoodstopMon, 08 Nov 2010 12:41:39 GMThttp://www.sqlmag.com/article/VisualStudioLightSwitch/Turning-On-To-LightSwitch-126007#commentsAnchorhttp://www.sqlmag.com/article/news2/readers-respond-about-microsoft-s-support-for-the-small-business-sector#commentsAnchorMon, 08 Nov 2010 12:27:10 GMT
Forgot to mention that Pervasive might also be a good candidate for comparison.]]>BennettMon, 08 Nov 2010 12:27:10 GMThttp://www.sqlmag.com/article/news2/readers-respond-about-microsoft-s-support-for-the-small-business-sector#commentsAnchorhttp://www.sqlmag.com/article/news2/readers-respond-about-microsoft-s-support-for-the-small-business-sector#commentsAnchorMon, 08 Nov 2010 12:26:16 GMT
Hi Michael,

Perhaps a comparison of MSSQL to another commercial product (like Sybase) would help put some light on what small business users really need from a supported SQL product.

Regards,
Bret Bennett]]>BennettMon, 08 Nov 2010 12:26:16 GMThttp://www.sqlmag.com/article/news2/readers-respond-about-microsoft-s-support-for-the-small-business-sector#commentsAnchorhttp://www.sqlmag.com/article/windows-server/hyper-v-live-migration-step-by-step#commentsAnchorTue, 02 Nov 2010 12:50:30 GMT
For the record, Aidan’s Mastering Hyper-V Deployment http://amzn.to/aKCQXj is now available on Kindle as well.]]>BoltonTue, 02 Nov 2010 12:50:30 GMThttp://www.sqlmag.com/article/windows-server/hyper-v-live-migration-step-by-step#commentsAnchorhttp://www.sqlmag.com/article/mobile-computing-devices/top-10-windows-phone-7-enterprise-features#commentsAnchorFri, 29 Oct 2010 05:39:07 GMT
Funny! Twittered a few minutes ago: http://twitter.com/#!/VosAJM/status/29074543416. Didn’t know your Twitter-ID :(
See article on: http://www.winsupersite.com/mobile/wp7_business.asp

Rgds, Arjan Vos]]>VosFri, 29 Oct 2010 05:39:07 GMThttp://www.sqlmag.com/article/mobile-computing-devices/top-10-windows-phone-7-enterprise-features#commentsAnchorhttp://www.sqlmag.com/article/sql-server/7-easy-asp-net-techniques#commentsAnchorFri, 29 Oct 2010 05:12:16 GMT
Why would you put a connection string in appSettings when there’s a ConnectionStrings element in webconfig that’s specifically designed for them. Note also that the System.Web.Configuration namespace has a WebConfigurationManager class, which is the more correct class to use in ASP.NET applications.]]>Phil PursgloveFri, 29 Oct 2010 05:12:16 GMThttp://www.sqlmag.com/article/sql-server/7-easy-asp-net-techniques#commentsAnchorhttp://www.sqlmag.com/article/news2/riding-the-virtualization-express-from-desktops-to-databases#commentsAnchorThu, 28 Oct 2010 14:53:02 GMT
Your image of a "virtual database" reminds me of Oracle’s RAC product. The database instances exist simultaneously on all nodes of the RAC cluster and the database files are on SAN attached storage visible to all database instances. A Broker network process watches all instances and can move user sessions between nodes if needed - in some cases without the user even knowing or "seeing" it. Each instance can have different memory tuning based on a purpose if needed. I would love to see this kind of setup for SQL Server - especially for disaster recovery.]]>BhattiThu, 28 Oct 2010 14:53:02 GMThttp://www.sqlmag.com/article/news2/riding-the-virtualization-express-from-desktops-to-databases#commentsAnchorhttp://www.sqlmag.com/article/mobile-computing-devices/top-10-windows-phone-7-enterprise-features#commentsAnchorTue, 26 Oct 2010 20:08:33 GMT
Are you sure the articles title is correct. Top 10 enterprise features, No way of centrally managing the device, no tethering, no SD card removal option,need I go on. These sound like my top 10 reasons not to buy a Windows phone 7 device. This is Vista all over again. Microsoft really have missed the boat here by targetting consumers first. This OS is NOT enterprise ready! ]]>KenningtonTue, 26 Oct 2010 20:08:33 GMThttp://www.sqlmag.com/article/mobile-computing-devices/top-10-windows-phone-7-enterprise-features#commentsAnchorhttp://www.sqlmag.com/article/mobile-computing-devices/top-10-windows-phone-7-enterprise-features#commentsAnchorTue, 26 Oct 2010 18:50:04 GMT
"Developers must use APIs to access these types of system resources." - Wow, really? And I thought developers could just access system resources by pure thought, or sometimes even by sticking their finger in a nice cup of warm tea... ;-)]]>PriestTue, 26 Oct 2010 18:50:04 GMThttp://www.sqlmag.com/article/mobile-computing-devices/top-10-windows-phone-7-enterprise-features#commentsAnchorhttp://www.sqlmag.com/article/hardware/new-features-in-sharepoint-2010#commentsAnchorTue, 26 Oct 2010 11:14:22 GMT
Sharepoint 2010 is indeed a very powerful collaborative platform and a lot of companies built very valuable and interested products & services on top of it.

As an example, "VIDIZMO for Sharepoint" allows you to add interactive video capabilities in your SharePoint for training, learning & communication.

VIDIZMO Empowers Schools, Universities, and Institutions Using SharePoint 2010/2007
http://www.i-newswire.com/vidizmo-empowers-schools-universities/68864

checkout vidizmo.com for more details.]]>KhanTue, 26 Oct 2010 11:14:22 GMThttp://www.sqlmag.com/article/hardware/new-features-in-sharepoint-2010#commentsAnchorhttp://www.sqlmag.com/article/database-development/nosql-no-way-#commentsAnchorThu, 14 Oct 2010 15:05:31 GMT
NoSQL does not mean non-relational.
http://relevantknowledge.wordpress.com/2010/10/04/why-nosql-does-not-mean-non-relational/]]>PORTASThu, 14 Oct 2010 15:05:31 GMThttp://www.sqlmag.com/article/database-development/nosql-no-way-#commentsAnchorhttp://www.sqlmag.com/article/database-development/nosql-no-way-#commentsAnchorFri, 01 Oct 2010 12:59:10 GMT
What about the January’s issue? MySpace addressed the same problems using SQL Server. I believe it is easier to use NoSQL than digg in SQL Server, that is the real reason. Almost like Linq. It is far easier for a programmer to learn Linq than it is to digg in TSQL.

Take Care!]]>GalvaniFri, 01 Oct 2010 12:59:10 GMThttp://www.sqlmag.com/article/database-development/nosql-no-way-#commentsAnchorhttp://www.sqlmag.com/article/database-development/nosql-no-way-#commentsAnchorFri, 24 Sep 2010 20:43:52 GMT
Twitter still uses MySQL for Tweets. I believe they had issues and stuck with MySQL, not Cassandra for the tweets. There is a June or July post about it from Twitter.

Furthermore, NoSQL is good for different purposes. Devs also need to know a lot about whatever NoSQL DB they choose to use b/c some do not operate exactly how they’d expect. For instance, when data is actually written to disk etc. ]]>KongFri, 24 Sep 2010 20:43:52 GMThttp://www.sqlmag.com/article/database-development/nosql-no-way-#commentsAnchorhttp://www.sqlmag.com/article/sql-azure-database/sql-server-vs-sql-azure-where-sql-azure-is-limited#commentsAnchorMon, 13 Sep 2010 06:46:15 GMT
It doesn’t support Linked server.]]>VILLEGASMon, 13 Sep 2010 06:46:15 GMThttp://www.sqlmag.com/article/sql-azure-database/sql-server-vs-sql-azure-where-sql-azure-is-limited#commentsAnchorhttp://www.sqlmag.com/article/sql-azure-database/sql-server-vs-sql-azure-where-sql-azure-is-limited#commentsAnchorThu, 09 Sep 2010 13:34:02 GMT
I agree. Not yet production ready, but certainly has some potential. ]]>LesterThu, 09 Sep 2010 13:34:02 GMThttp://www.sqlmag.com/article/sql-azure-database/sql-server-vs-sql-azure-where-sql-azure-is-limited#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2008-r2/sql-server-service-broker-the-subsystem-you-never-knew-you-needed#commentsAnchorMon, 06 Sep 2010 15:03:36 GMT
Hello:

Service Broker is great feature but it has limitation based on business requirement. you quoted e.g. fom Myspace, can you tell me how many tables they are replicating to 450+ servers.

I don’t know how many but i think not more than 2-3 tables.

Can you tell me any real world application or test which proves that Service Broker scale well with 10+ tables or say 14-15 tables.

Even though if you process with 10+ tables in just one queue rather than 3-4 queues, it will be mess.

Please forward me the link where 10+ tables are processed or replicated using SB.

That it will help me to educate & lesson learned from it.

Thanks
]]>DaveMon, 06 Sep 2010 15:03:36 GMThttp://www.sqlmag.com/article/sql-server-2008-r2/sql-server-service-broker-the-subsystem-you-never-knew-you-needed#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2008-r2/sql-server-service-broker-the-subsystem-you-never-knew-you-needed#commentsAnchorFri, 03 Sep 2010 09:33:31 GMT
I agree that Service Broker is a bit of a stretch for database folks who are used to tables, procedures etc., but once they work with it, I think it starts to make sense pretty quickly What Microsoft has done is to create message queueing tool that is wrapped in TSQL - the langauge familiar to DBAs. As to why one should use WCF over Service Broker, DBAs may not have WCF or MSMQ in their toolset. With TSQL, they can create a message queueing system that is very robust. Regarding what business problems does it solve, any problem where messages need to be passed between applications, between databases and between applications and databases. For example, I have an SSIS package that sends a broker message to the External Activator which starts up an application on a remote server. The remote server processes the data and sends a message back to the SSIS package. Once SSIS gets the message it continues on with its processing. Sure WCF and MSMQ could solve those problems. But not all shops will have the resources to impliment those type of solutions.

Another area where I have used Service Broker is to execute SSIS packages from an applicaton. Since SSIS packages cannot be executed remotely like DTS packages could, I can have the application send a broker message to SQL Server to execute a stored procedure which executes the package via DTExec. When the package is finished, it sends a broker message back to the application’s queue, and the application proceeds from there. The stored procedure can be generic and the broker message can contain the name of the SSIS package to execute.]]>macqueenFri, 03 Sep 2010 09:33:31 GMThttp://www.sqlmag.com/article/sql-server-2008-r2/sql-server-service-broker-the-subsystem-you-never-knew-you-needed#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2000/is-sql-server-2008-r2-for-you-#commentsAnchorThu, 02 Sep 2010 13:27:25 GMT
Hi Micheal,
I was reading your book on SQL Server 2008 High Availability. You wrote, on page 27, that integration services and reporting services are fully clustered aware.

However, BOL sates, "Microsoft does not recommend that the Integration Services service be configured as a cluster resource."

I found it bit confusing. I would appreciate if you could shed more light on it.

Thanks,
Najm]]>HashmiThu, 02 Sep 2010 13:27:25 GMThttp://www.sqlmag.com/article/sql-server-2000/is-sql-server-2008-r2-for-you-#commentsAnchorhttp://www.sqlmag.com/article/sql-azure-database/sql-server-vs-sql-azure-where-sql-azure-is-limited#commentsAnchorThu, 02 Sep 2010 06:49:57 GMT
Then, really is SQL Azure ready to put in production our databases?

I don’t think so]]>Francisco RacioneroThu, 02 Sep 2010 06:49:57 GMThttp://www.sqlmag.com/article/sql-azure-database/sql-server-vs-sql-azure-where-sql-azure-is-limited#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2008-r2/sql-server-service-broker-the-subsystem-you-never-knew-you-needed#commentsAnchorFri, 27 Aug 2010 21:05:14 GMT
"And then, there is the problem of awareness: Many people who dont use Service Broker dont understand its practical value."

I think Microsoft has to take a lot of the blame for that. They really haven’t made much of an effort to explain their vision of Service Broker. What business problem were they trying to solve with it? Why would I choose to implement Service Broker rather than a technology like WCF? I’ve been curious about what I can do with Service Broker since it was introduced, but finding useful information about it has been next to impossible.]]>Kenneth PowersFri, 27 Aug 2010 21:05:14 GMThttp://www.sqlmag.com/article/sql-server-2008-r2/sql-server-service-broker-the-subsystem-you-never-knew-you-needed#commentsAnchorhttp://www.sqlmag.com/article/database-administration/who-owns-database-design#commentsAnchorMon, 23 Aug 2010 04:57:26 GMT
No comments yet? I guess it’s vactaion time ! I would say that anyone who calls themselves a professional web developer in 2010 should know the front end, business layer and back end(ie the database). I met some folks a few weeks ago who were using NHibernate and were clearly uncomfortable about straying into database territory when I asked them how efficient the generated SQL was . Everything depends on the data/database and if you cannot define entities at a relational level and walk through all the transactions by hand to prove you can get it efficiently, you are kidding yourself.]]>McCreightMon, 23 Aug 2010 04:57:26 GMThttp://www.sqlmag.com/article/database-administration/who-owns-database-design#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2000/is-sql-server-2008-r2-for-you-#commentsAnchorTue, 17 Aug 2010 06:43:26 GMT
If youre looking to give your application or solution the best chance of success by ensuring that they are compatible with the latest versions of Microsoft SQL Server 2008 R2 then check out http://bit.ly/MicrosoftPartnerNetwork where you can gain access to testing, technical readiness and support resources.]]>DigitalisTue, 17 Aug 2010 06:43:26 GMThttp://www.sqlmag.com/article/sql-server-2000/is-sql-server-2008-r2-for-you-#commentsAnchor