• VB.NET Class Library: DBIO SQL

    Updated: 2010-05-31 06:12:10
    A plug-in database I/O layer for SQL databases with automatic SQL statements

  • VB.NET Class Library: DBIO Access

    Updated: 2010-05-31 06:12:10
    A plug-in database I/O layer for Access databases with automatic SQL statements

  • SQLAuthority News – Monthly Roundup of Best SQL Posts

    Updated: 2010-05-31 02:30:56
    After receiving lots of requests from different readers for long time I have decided to write first monthly round up. If all of you like it I will continue writing the same every month. In fact, I really like the idea as I was able to go back and read all of my posts written [...]

  • Pre-Conference Sessions at the PASS Summit

    Updated: 2010-05-30 18:04:00
    Introduction I have some thoughts on the selection of pre-conference and post-conference session presenters at the PASS Summit. PASS pre-conference and post-conference sessions are $395. Trainers and speakers in the various SQL Server fields (relational engine, business intelligence, etc.) are selected to deliver these day-long seminars before and (now) after each PASS Summit. I have attended a few and the quality and amount of the training easily justifies the $395 price tag. Full Disclosure I've...(read more)

  • SQLAuthority News – Guest Post – Performance Counters Gathering using Powershell

    Updated: 2010-05-30 02:30:01
    Laerte Junior Laerte Junior has previously helped me personally to resolve the issue with Powershell installation on my computer. He did awesome job to help. He has send this another wonderful article regarding performance counter for readers of this blog. I really liked it and I expect all of you who are Powershell geeks, you [...]

  • Dynamic Unpivot : SSIS Nugget

    Updated: 2010-05-29 07:10:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in SSIS Junkie Entire Site Search Home Blogs Forums Downloads Opml SSIS Junkie Get your SSIS fix Dynamic Unpivot SSIS Nugget A question on the SSIS forum earlier today : asked I need to dynamically unpivot some set of columns in my source file . Every month there is one new column and its set of Values . I want to unpivot it without editing my SSIS packages that is deployed Let’s be clear about what we mean by Unpivot . It is a normalisation technique that basically converts columns into rows . By way of example it converts something like : this AccountCode Jan Feb Mar AC1 100.00 150.00 125.00 AC2 45.00 75.50 90.00 into something like : this AccountCode Month Amount AC1 Jan

  • SQLAuthority News – Guest Post – FAULT Contract in WCF with Learning Video

    Updated: 2010-05-29 02:30:51
    This is guest post by one of my very good friends and .NET MVP, Dhananjay Kumar. The very first impression one gets when they meet him is his politeness. He is an extremely nice person, but has superlative knowledge in .NET and is truly helpful to all of us. Objective: This article will give a [...]

  • Protecting ADO.NET applications Part I

    Updated: 2010-05-28 20:30:00
    Protecting ADO.NET applications Part I

  • SSIS – Delete all files except for the most recent one

    Updated: 2010-05-28 12:53:57
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Jorg Klein Entire Site Search Home Blogs Forums Downloads Opml Jorg Klein Jorg Klein , Microsoft-only BI consultant from the Netherlands , blogging about BI on SQL Server with a focus on . SSIS SSIS Delete all files except for the most recent one Quite often one or more sources for a data warehouse consist of flat files . Most of the times these files are delivered as a zip file with a date in the file name , for example FinanceDataExport_20100528.zip Currently I work at a project that does a full load into the data warehouse every night . A zip file with some flat files in it is dropped in a directory on a daily basis . Sometimes there are multiple zip files in the directory

  • SSIS is Case-Sensitive

    Updated: 2010-05-28 12:00:00
    Introduction SSIS is case-sensitive even if the database is case-insensitive. Imagine... ... you work in an ETL shop where someone who believes in natural keys won the Battle of the Joins. Imagine one of your natural keys is a string. (I know it's a stretch... play along!). Let's build some tables to sketch it out. If you do not have a TestDB database, why not? Build one! You'll use it often. Use TestDB go Create Table SSIS1 ( StrID char ( 5 ) , Name varchar ( 15 ) , Value int ) Insert Into SSIS1...(read more)

  • Adding included columns to indexes using SMO

    Updated: 2010-05-28 06:50:00
    A question came up on the SQL Down Under mailing list today about how to add an included column to an index using SMO. A quick search of the documentation didn't seem to reveal any clues but a little investigation turned up what's needed: the IndexedColumn class has an IsIncluded property. Index i = new Index (); IndexedColumn ic = new IndexedColumn (i, "somecolumn" ); ic.IsIncluded = true ; Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!...(read more)

  • SQL SERVER – Disabled Index and Update Statistics

    Updated: 2010-05-28 02:30:55
    When we try to update the statistics, it throws an error as if the clustered index is disabled. Now let us enable the clustered index only and attempt to update the statistics of the table right after that. Have you ever come across the situation where a conversation never gets over and it continues even [...]

  • Quote of the Day: When You Find that the Ordinary, Isn't

    Updated: 2010-05-28 01:20:13
    : , THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Buck Woody Entire Site Search Home Blogs Forums Downloads Opml Buck Woody Carpe Datum Quote of the Day : When You Find that the Ordinary , Isn't The wise man is astonished by anything . Andre Gide Share this : post email it bookmark it digg it reddit kick it live it Published Friday , May 28, 2010 6:20 AM by BuckWoody Filed under : Quote Of The Day Comment Notification If you would like to receive an email when updates are made to this post , please register here Subscribe to this post's comments using RSS Comments Twitter Trackbacks for Buck Woody Quote of the Day : When You Find that the Ordinary , Isn't sqlblog.com on Topsy.com : said PingBack from http : topsy.com

  • SQL University: Parallelism Week - Part 3, Settings and Options

    Updated: 2010-05-28 01:00:00
    Congratulations! You've made it back for the the third and final installment of Parallelism Week here at SQL University . So far we've covered the fundamentals of multitasking vs. parallel processing and delved into how parallel query plans actually work . Today we'll take a look at the settings and options that influence intra-query parallelism and discuss how best to set things up in various situations. Instance-Level Configuration Your database server probably has more than one logical processor....(read more)

  • I think I’ve finally made it in life. I have a Bobblehead.

    Updated: 2010-05-27 20:33:21
    . . THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Buck Woody Entire Site Search Home Blogs Forums Downloads Opml Buck Woody Carpe Datum I think I’ve finally made it in life . I have a Bobblehead . I have no idea why the Marketing group at Microsoft made me into a Bobblehead . Other than this is awesome I think I’ll call him Lil . Buck” Share this : post email it bookmark it digg it reddit kick it live it Published Thursday , May 27, 2010 1:33 PM by BuckWoody Filed under : Rant Comment Notification If you would like to receive an email when updates are made to this post , please register here Subscribe to this post's comments using RSS Comments No Comments Leave a Comment Name required Your URL optional Comments required

  • Oracle to SQL Server: Crossing the Great Divide, Part 2

    Updated: 2010-05-27 14:03:39
    A well-known Oracle expert records faithfully his struggles with the unfamiliar : SQL Server. He now sets himself the task of creating a table with a million rows of random data. As one might expect, it is the lack of familiarity with the workarounds and tricks of SQL Server that trips him up. His journey brings us fresh insights, and a glimpse at the alternative-universe of Oracle.

  • Set-based Speed Phreakery: The FIFO Stock Inventory SQL Problem

    Updated: 2010-05-27 14:03:38
    The SQL Speed Freak Challenge is a no-holds-barred competition to find the fastest way in SQL Server to perform a real-life database task. It is the programming equivalent of drag racing, but without the commentary box. Kathi has stepped in to explain what happened with the second challenge and why some SQL ran faster than others.

  • SQL Server APPLY Basics

    Updated: 2010-05-27 14:03:36
    One of the most interesting additions to SQL Server syntax in SQL Server 2005 was the APPLY operator. It allows several queries that were previously impossible. It is surprisingly difficult to find a simple explanation of what APPLY actually does. Rob Sheldon is the specialist in simple explanations, so we asked him.

  • Mission Critical: SQL Server General Configuration

    Updated: 2010-05-27 14:03:36
    You know how to set up a SQL Server instance, but it is great to have a list of all the necessary checks and procedures: even better is to have the link to in-depth explanations for every stage by the renowned SQL Server Expert Buck Woody.

  • T-SQL Snack: How Much Free Storage Space is Available?

    Updated: 2010-05-27 12:00:00
    Introduction Ever have a need to calculate the total available storage space for a server? Recently I did. Here's a solution I came up with - I bet someone can do this better! xp_fixeddrives There's a handy stored procedure called xp_fixeddrives that reports the available storage space: exec xp_fixeddrives This returns: drive MB free ----- ----------- C 6998 E 201066 Problem solved right? Maybe. The Sum What I really want is the sum total of all available space presented to the server. I built this...(read more)

  • Striving to be boring - or at least have boring systems

    Updated: 2010-05-27 05:56:00
    A developer I work with, whom I respect a great deal, reminded me of this truism today. I'm not sure who came up with the original, but they deserve credit wherever they are: “A good system administrator is a bored system administrator.” As a DBA, this really rings true for me. Being a DBA should not be a thrilling job. Within reason, there should not be myriad surprises, nor a roller coaster ride, wondering what will break each day. There should not be numerous 2 AM calls or frantic fixes. If there...(read more)

  • SQL SERVER – DATE and TIME in SQL Server 2008

    Updated: 2010-05-27 02:30:38
    I was thinking about DATE and TIME datatypes in SQL Server 2008. I earlier wrote about the about best practices of the same. Recently I had written one of the script written for SQL Server 2008 had to run on SQL Server 2005 (don’t ask me why!), I had to convert the DATE and TIME [...]

  • The Most Effective Learning Methods – The Results

    Updated: 2010-05-27 01:46:14
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Buck Woody Entire Site Search Home Blogs Forums Downloads Opml Buck Woody Carpe Datum The Most Effective Learning Methods The Results Yesterday I posted a blank graph and asked where you thought the labels should go for the most effective learning methods , according to a study they read to me and other teachers here at the University of Washington . Here are the labels in the correct order according to that study and remember , Teaching” here means one student explaining something to another : It isn’t really that surprising to learn that we comprehend best when we have to teach a subject to someone else , and you can see that the participation factor” is the key in the

  • How to start with PowerPivot for Excel

    Updated: 2010-05-26 12:46:29
    Now that Office 2010 has been released, many people will start looking for resources to start learning PowerPivot. Of course, the book I’m writing will be helpful when it will be published (September 2010), but you can also start with some online content on Microsoft sites. First of all, this is the web site dedicated to PowerPivot: http://www.powerpivot.com/ It contains several videos and demos and it’s also possible to use a Virtual Lab without installing Office 2010 on your PC. Then, there is...(read more)

  • Sessions I Submitted to the PASS Summit 2010

    Updated: 2010-05-26 12:00:00
    Introduction I'm borrowing an idea and blog post title from Brent Ozar ( Blog - @BrentO ). I am honored the PASS Summit 2010 (Seattle, 8 - 11 Nov 2010) would consider allowing me to present. It's a truly awesome event. If you have an opportunity to attend and read this blog, please find me and introduce yourself. If you've built a cool solution to a business or technical problem; or written a script - or a bunch of scripts - to automate part of your daily / weekly / monthly routine; or have some...(read more)

  • What are the most effective learning methods?

    Updated: 2010-05-26 11:09:17
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Buck Woody Entire Site Search Home Blogs Forums Downloads Opml Buck Woody Carpe Datum What are the most effective learning methods After I got done speaking at the SQL Server 2008 R2 Launch Event yesterday I came back to the hotel room for a web-meeting with some of the other teachers at the University of Washington . As teachers we are always looking to improve the knowledge transfer to our students and the Program Director found an interesting study that I thought I might share here . Below is an un-labeled chart showing the effectiveness of learning methods according to a recent study . At the top are the labels . Teaching here means students teaching each other Try the

  • Why I don’t need to go on the SQLCruise

    Updated: 2010-05-26 04:04:00
    Brent Ozar ( Blog | Twitter ) and Tim Ford ( Blog | Twitter ) are putting on a new type of event in the month of August after SQL Saturday #40 in South Florida July, 31st , properly named SQLCruise . The concept is great, at least in my opinion, you pay for a cruise, get to have a break, and at the same time attend a mini-conference on SQL Server with training provided by two great speakers. The cost is relatively affordable, so what could possibly make it better? How about a sponsor offering up...(read more)

  • SQLAuthority News – SQL Server Technology Evangelists and Evangelism

    Updated: 2010-05-26 02:30:57
    This is the exact conversation that I had with three people during the recent SQL Server Public Training. Person 1: “Are you an SQL Server Evangelist?” Pinal : “No, but Vinod Kumar is.” Person 1: “Who are you?” Person 2: “He is Pinal, haha!” Person 1: “I know that, but don’t you evangelize SQL Server [...]

  • SQLAuthority News – Win MS Office License – Last 2 days

    Updated: 2010-05-26 02:30:39
    Just a note for everybody who is from India and want to win FREE Office License, participate in very easy contest here. SQLAuthority News – Virtual Launch Event for Office 2010 – Contest – Win MS Office License Reference: Pinal Dave (http://blog.sqlauthority.com) Filed under: SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, [...]

  • SQL University: Parallelism Week - Part 2, Query Processing

    Updated: 2010-05-26 01:00:00
    Welcome back for the second part of Parallelism Week here at SQL University . Get your pencils ready, and make sure to raise your hand if you have a question. Last time we covered the necessary background material to help you understand how the SQL Server Operating System schedules its many active threads, and the differences between its behavior and that of the Windows operating system's scheduler. We also discussed some of the variations on the theme of parallel processing. Today we'll take a look...(read more)

  • Data-tier Applications in SQL Server 2008 R2

    Updated: 2010-05-25 11:47:45
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Buck Woody Entire Site Search Home Blogs Forums Downloads Opml Buck Woody Carpe Datum Data-tier Applications in SQL Server 2008 R2 I had the privilege of presenting to the Adelaide SQL Server User Group in Australia last evening , and I covered the Data Access Component DAC and the Utility Control Point UCP from SQL Server 2008 R2. Here are some links from that : presentation Whitepaper : http : msdn.microsoft.com en-us library ff381683.aspx Tutorials : http : msdn.microsoft.com en-us library ee210554(SQL.105 aspx From Visual Studio : http : msdn.microsoft.com en-us library dd193245(VS.100 aspx Restrictions and capabilities by Edition : http : msdn.microsoft.com en-us library

  • Rounding functions in DAX

    Updated: 2010-05-25 11:03:00
    Today I prepared a table of the many rounding functions available in DAX (yes, it’s part of the book we’re writing), so that I have a complete schema of the better function to use, depending on the round operation I need to do. Here is the list of functions used and then the results shown for a relevant set of values. FLOOR = FLOOR( Tests[Value], 0.01 ) TRUNC = TRUNC( Tests[Value], 2 ) ROUNDDOWN = ROUNDDOWN( Tests[Value], 2 ) MROUND = MROUND( Tests[Value], 0.01 ) ROUND = ROUND( Tests[Value], 2 )...(read more)

  • Reinventing the Wheel – Automating Data Consistency Checks with Powershell

    Updated: 2010-05-25 06:24:02
    When I started in my current position at the beginning of the year, one of the first things that I did was to schedule a sit down with the various teams of Analysts that exist in our organization to find out more about their systems.  One thing I am always interested in is the manual processes that people do routinely that might be able to be automated.   A couple of the analyst mentioned that they routinely run queries in their systems to identify issues so that they can proactively...(read more)

  • Microsoft Assessment and Planning (MAP) Toolkit 5.0 Beta

    Updated: 2010-05-25 04:19:00
    Do you know where SQL Server is installed - everywhere it is installed? Do you really know where SQL Server is installed? Are you looking for a tool that will help you discover any rogue instances so you can better manage these instances? The Beta 2 for the Microsoft Assessment and Planning (MAP) Toolkit 5.0 is now open. Join the beta review program and help influence the development of the toolkit. To participate, register for the MAP Toolkit 5.0 Beta 2 at Microsoft Connect. The MAP Toolkit 5.0...(read more)

  • SQLAuthority News – Whitepaper – SQL Azure vs. SQL Server

    Updated: 2010-05-25 02:30:09
    SQL Server and SQL Azure are two Microsoft Products which goes almost together. There are plenty of misconceptions about SQL Azure. I have seen enough developers not planning for SQL Azure because they are not sure what exactly they are getting into. Some are confused thinking Azure is not powerful enough. I disagree and strongly [...]

  • Two Free Training Webcasts Open for Registration

    Updated: 2010-05-24 21:59:00
    We've got two sessions that you need to sign up for right away. The upcoming webcast for Oracle-oriented folks has huge registration numbers. So get in while you still can before we hit the limit of what LiveMeeting can handle. Pain of the Week: SQL Server for the Oracle DBA Webcast: SQL Server for the Oracle DBA Date: Thursday, May 27, 2010 (Just a couple days hence!) Time: 8 a.m. Pacific / 11 a.m. Eastern / 4 p.m. United Kingdom / 5 p.m. Central Europe Duration: 45-60 minutes Cost: FREE In enterprise...(read more)

  • Mission Critical: SQL Server Upgrade

    Updated: 2010-05-24 19:22:10
    You're faced with the task of doing a SQL Server Upgrade? Do you know all the steps, and the right order to do them? You do? Even with interruptions and distractions? Maybe, but it is wise to be able to refer to the Mission-Critical Task checklist.

  • SQLAuthority News – Microsoft SQL Server 2008 R2 – PowerPivot for Microsoft Excel 2010

    Updated: 2010-05-24 02:30:51
    Microsoft has really and truly created some buzz for PowerPivot. I have been asked to show the demo of Powerpivot in recent time even when I am doing relational database training. Attached is the few details where everyone can download PowerPivot and use the same. Microsoft SQL Server 2008 R2 – PowerPivot for Microsoft Excel [...]

  • SQL SERVER – Check the Isolation Level with DBCC useroptions

    Updated: 2010-05-24 02:30:47
    In recent consultancy project coordinator asked me – “can you tell me what is the isolation level for this database?” I have worked with different isolation levels but have not ever queried database for the same. I quickly looked up bookonline and found out the DBCC command which can give me the same details. You [...]

  • SQLAuthority News – Virtual Launch Event for Office 2010 – Contest – Win MS Office License

    Updated: 2010-05-23 02:30:06
    Office products are integral products of any PC. I accept that without Office Suites, I can not survive or make enough leaving. I am blogger and use word to create my blogs. I am SQL Server Trainer  and I use PowerPoint as my presentation tool. I am SQL Server consultant and I use Excel to [...]

  • Operator of the Week - Spools, Eager Spool

    Updated: 2010-05-22 22:52:13
    For the fifth part of Fabiano's mission to describe the major Showplan Operators used by SQL Server's Query Optimiser, he introduces the spool operators and particularly the Eager Spool, explains blocking and non-blocking and then describes how the Halloween Problem is avoided.

  • SQLAuthority News – Downloads Available for Microsoft SQL Server Compact 3.5

    Updated: 2010-05-22 02:30:35
    There are few downloads released for Microsoft SQL Server Compact 3.5. Here is quick lists of the same. Microsoft SQL Server Compact 3.5 Service Pack 2 for Windows Desktop SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the [...]

  • SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions

    Updated: 2010-05-21 02:30:06
    To learn any technology and move to a more advanced level, it is very important to understand the fundamentals of the subject first. Today, we will be talking about something which has been quite introduced a long time ago but not properly explored when it comes to the isolation level. Snapshot Isolation was introduced in [...]

  • Database Export Wizard for ASP.net and SQL Server

    Updated: 2010-05-20 16:55:00
    A step wizard for ASP.net to export database objects to CSV, TXT, HTML, XML, or SQL.

  • SQLAuthority News – Professional Development and Community

    Updated: 2010-05-20 02:30:53
    I was recently invited by Hyderabad Techies to deliver a keynote for their 16-day online session called TECH THUNDERS. This event has been running from May 15 and will continue up to the end of the month May 30). There would be a total of 30 sessions. In every evening of those 16 day, there [...]

  • SQLAuthority News – Updated Favorite Scripts and Best Articles Page

    Updated: 2010-05-19 02:30:37
    I have been writing on this blog for around 4 years now and have contributed with more than 1300 blog posts. Many times, I have been asked regarding what is my most favorite article or which is the most essential script for developers and DBA. This is very difficult to answer as I so much [...]

  • SQLAuthority Book Review – DBA Survivor: Become a Rock Star DBA

    Updated: 2010-05-18 02:30:25
    DBA Survivor: Become a Rock Star DBA – Thomas LaRock Link to Amazon Link to Flipkart First of all, I thank all my readers when I wrote that I could not get this book in any local book stores, because they offered me to send a copy of this good book. A very special mention [...]

  • SQLAuthority News – Bookmark – Deprecated Database Engine Features in SQL Server 2008

    Updated: 2010-05-17 02:30:24
    When anyone asked me if any specific feature is available in SQL Server 2008 or if any feature will be disabled in future versions of SQL Server, I always pointed to the following list where all the deprecated database engine features are listed. Deprecated Database Engine Features in SQL Server 2008 R2 Deprecated Database Engine [...]

  • SQLAuthority News – Storage and SQL Server Capacity Planning and configuration – SharePoint Server 2010

    Updated: 2010-05-16 02:30:12
    Just a day ago, I was asked how do you plan SQL Server Storage Capacity. Here is the excellent article published by Microsoft regarding SQL Server capacity planning for SharePoint 2010. This article touches all the vital areas of this subject. Here are the bullet points for the same. Gather storage and SQL Server space [...]

  • SQL SERVER – List All the DMV and DMF on Server

    Updated: 2010-05-15 02:30:52
    “How many DMVs and DVFs are there in SQL Server 2008?” – this question was asked to me in one of the recent SQL Server Trainings. Answer is very simple: SELECT name, type, type_desc FROM sys.system_objects WHERE name LIKE 'dm_%' ORDER BY name Update: Madhivanan has corrected the script here. Reference: Pinal Dave (http://blog.sqlauthority.com) Filed under: [...]

  • Reliable Storage Systems for SQL Server

    Updated: 2010-05-14 05:41:56
    By validating the IO path before commissioning the production database system, and performing ongoing validation through page checksums and DBCC checks, you can hopefully avoid data corruption altogether, or at least nip it in the bud. If corruption occurs, then you have to take the right decisions fast to deal with it. Rod Colledge explains how a pessimistic mindset can be an advantage

  • SQL SERVER – Find Most Expensive Queries Using DMV

    Updated: 2010-05-14 02:30:20
    The title of this post is what I can express here for this quick blog post. I was asked in recent query tuning consultation project, if I can share my script which I use to figure out which is the most expensive queries are running on SQL Server. This script is very basic and very [...]

  • SQL SERVER – Four Posts on Removing the Bookmark Lookup – Key Lookup

    Updated: 2010-05-13 02:30:05
    Recently, I have observed that not many people have proper understanding of what is bookmark lookup or key lookup. Increasing numbers of the questions tells me that this is something that developers encounter every single day, but have no idea how to deal with. I have previously written three posts on this subject. All those [...]

  • SQL SERVER – Understanding ALTER INDEX ALL REBUILD with Disabled Clustered Index

    Updated: 2010-05-12 02:30:45
    This blog is in response to the ongoing communication with the reader who had earlier asked the question of SQL SERVER – Disable Clustered Index and Data Insert. The same reader has asked me the difference between ALTER INDEX ALL REBUILD and ALTER INDEX REBUILD along with disabled clustered index. Instead of writing a big [...]

  • SQL SERVER – Spatial Database Queries – What About BLOB – T-SQL Tuesday #006

    Updated: 2010-05-11 02:30:22
    Michael Coles is one of the most interesting book authors I have ever met. He has a flair of writing complex stuff in a simple language. There are a very few people like that.  I really enjoyed reading his recent book, Expert SQL Server 2008 Encryption. I strongly suggest taking a look at it. This [...]

  • SQL SERVER – Size of Index Table for Each Index – Solution 3 – Powershell

    Updated: 2010-05-10 02:30:00
    Laerte Junior If you are a Powershell user, the name of the Laerte Junior is not a new name. He is the one man with exceptional knowledge of Powershell. He is not only very knowledgeable, but also very kind and eager to those in need. I have been attempting to setup Powershell for many days, [...]<img alt="" border="0" src="http://stats.wordpress.com/b.gif?host=blog.sqlauthority.com&blog=668536&post=8925&subd=sqlauthority&ref=&feed=1" /

  • Getting error 2337 installing SQL Server on a VPC?

    Updated: 2010-05-09 17:50:00
    Home Syndication Log in Getting error 2337 installing SQL Server on a VPC I usually have a number of different versions of SQL Server around , installed on Virtual PCs . Usually works fine . So I was a bit surprised when installing the RTM version of SQL Server 2008 R2 from the downloaded iso file to receive error message 2337 in the middle of the install . Thinking it was something wrong with my download IIRC 2337 is a some kind of IO error during install I re-downloaded the iso . Same error . I then tried installing SP2 on my virtual Windows Server 2008 OS , then installing SQL Server again . No luck . Moved the iso from the portable Passport drive to the C : drive on the host OS . Nope . Since this error occured during install of SQL Server database itself , there was no possibility of

  • SQL SERVER – Size of Index Table for Each Index – Solution 2

    Updated: 2010-05-09 02:30:05
    Earlier I had ran puzzle where I asked question regarding size of index table for each index in database over here SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table. I had received good amount answers and I had blogged about that here SQL SERVER [...]

  • Recompiling the StreamInsight CTP3 samples for 1.0 - Part 3

    Updated: 2010-05-04 20:33:00
    Home Syndication Log in Recompiling the StreamInsight CTP3 samples for 1.0 Part 3 This posting is a journey through StreamInsight 1.0 APIs , undertaking by porting the CTP3 samples . Part 3. In the StreamInsight CTPs , there existed three methods to code applications . My original post describes the current state of Observable . That leaves us with Explicit Server and Implicit Server Coding using the Implicit Server method , nbsp you'd make basically two main calls . You'd create a CepStream with input provider information . Then use stream.ToQuery( . specifying output provider information . This call would not only bind the query , but create a Server and Application object under the covers . Since I'm not sure this is the reasoning your Server object must specify the correct

  • Recompiling the StreamInsight CTP3 samples for 1.0 - Part 2

    Updated: 2010-05-04 20:32:00
    Home Syndication Log in Recompiling the StreamInsight CTP3 samples for 1.0 Part 3 Recompiling the StreamInsight CTP3 samples for 1.0 Part 2 This posting is a journey through StreamInsight 1.0 APIs , undertaking by porting the CTP3 samples . Part 2. So let's update the SimulatedDataInputFactory provider , now . The problem seems to be the replacement of the interface that allows you to configure the CTI frequency . Sure enough , ITypedDeclareAdvanceTimePolicy has been replaced by ITypedDeclareAdvanceTimeProperties . In SimulatedDataInputFactory.cs 1. Change the interface declaration to the new name above ITypedDeclareAdvanceTimeProperties . 2. This interface has one method that now returns a AdapterAdvanceTimeSettings instead of an AdvanceTimeSetting . So change the code declaration at the

  • Recompiling the StreamInsight CTP3 samples for 1.0 - Part 1

    Updated: 2010-05-04 20:29:00
    Home Syndication Log in Recompiling the StreamInsight CTP3 samples for 1.0 Part 2 Recompiling the StreamInsight CTP3 samples for 1.0 Part 1 This posting is a journey through StreamInsight 1.0 APIs , undertaking by porting the CTP3 samples . The first look at the errors produced by recompiling the CTP3 examples is the realization that the IObservable model for coding adapters doesn't exist in the RTM version . This is quickly confirmed with a look at a StreamInsight forum thread it may return in future . Meanwhile , use the reactive framework . So I removed the Observable and PatternDetector projects for the samples solution . Concentrated on making the projects compile , first off . So , here's a list of the code that had to be changed for that purpose . In ExplicitServer.cs 1.

  • StreamInsight 1.0 RTM: Installation and Samples

    Updated: 2010-05-04 20:25:00
    : Home Syndication Log in Recompiling the StreamInsight CTP3 samples for 1.0 Part 1 StreamInsight 1.0 RTM : Installation and Samples StreamInsight V1.0 RTM'd a few weeks ago . Although I worked with it , looking especially at the infrastructure and programming models , I just installed the RTM version a few days ago . One thing I noticed immediately upon install is that it requires a license key . This is because there are different versions of StreamInsight based upon which SQL Server SKU you'd installed . See the licensing explanation , versioning , and SKUs information here Because I hadn't yet installed SQL Server 2008 R2, I chose to enter no license key , which meant that I installed the 180-day trial version . Now that SQL Server 2008 R2 is available via MSDN , I'll need to revisit

Current Feed Items | Previous Months Items

Apr 2010 | Mar 2010 | Feb 2010 | Jan 2010 | Dec 2009 | Nov 2009