Tag | SQL Posts

A customer of mine for years has been using a very expensive bit of labelling software to produce pallet labels. I’ve made use of this software invoking it from the command line to print labels from a windows service that polls a database table of print jobs. This has worked very nicely, in that all the web-services for my mobile application need to-do is drop a description of what label needs to be produced and what printer to send it to into a row in a database table, and my service does the rest. ...
Problem As the DBA, you need to determine if there are any databases in your production environment which have not had a full backup in the last 24 hours. In this tip we cover the step by step process for setting up a policy to identify all the databases which are not backed up in the last 24 hours. Solution Database Administrators can use Policy Based Management (PBM) to identify databases which have not backed up in the last 24 hours. You can follow the below steps to create and evaluate the policy. ...
Here is a simple way to combine values into one field using T-SQL. This method is particularly handy when you don’t know ahead of time how many values will be returned. This simple example would return a student’s name and list of professors (separated by commas). SELECT stu.FullName, (SELECT prof.FullName + ', ' FROM tblProfessors prof INNER JOIN tblStuProf stuprof ON prof.ProfID = stuprof.ProfID WHERE stuprof.StuID = 1234 FOR XML PATH('')) AS Professors from tblStudents stu where stu.StuID = 1234 ...
Model Functionality · Support for Enums for property types from lookup tables · Allow default date = DateTime.Now - The only way to set a default date in the entity data model is to put a hard date in there, a string. If you have a known default date (e.g. 1900-01-01) this is fine. But often we want NOW to be the default and there's no way to indicate that in the model. · Support for System.IO.Stream instead of Byte[] for varbinary type of fields · Support GUID as Entity Key -http://leedumond.com/blog/... ...
Merge Wpf and Silverlight to single framework · Merge both frameworks to use the same assemblies and controls (with optional functionality in separate assemblies) make a .net silverlight profile that would be a subset of .net client profile and used by partially trusted xaps. · Conditional compilation within Xaml - stopgap solution: for Silverlight/WPF differences in shared markup. · Support the direct hosting of Silverlight – stopgap solution: support the direct hosting of Silverlight in a WPF application ...
For those that didn’t know, I have recently left a long run at Thomson Reuters (which is a great company BTW) for a new gig as CIO of Swank Motion Pictures. This company works in the movie distribution business to cruise ships, trains, universities, and more. Some links if you are interested: http://www.onboardmovies.com/ http://www.swank.com/colleg... https://www.swankhealth.com http://www.k12digitalmovies... http://www.swank.com/digita... and more more more …. The thing is that ...
We recently switched over a client’s small infrastructure to Small Business Server 2008. SBS 2008 has SQL 2008 and Exchange 2007 imbedded. The customer wanted to keep the same internal and external FQDN names used previously with Exchange 2003. I had them purchase a SAN certificate with all the standard names in an Exchange 2007 or 2010 environment. We installed the certificate, made sure everything was set in both internal and external DNS, and started setting up clients. Webmail and Active-Sync ...
For those who haven’t come across it, PowerPivot is Microsoft’s Excel- and SharePoint-based self-service BI tool. Essentially, it allows power users to build their own SQL Server Analysis Services cubes, except that they don’t need to be familiar with cube concepts and they won’t even notice that SSAS is involved. The other exception from the Microsoft BI norm is that these cubes use a new columnar, in-memory storage engine, called VertiPaq, rather than Analysis Services’ traditional MOLAP (Multidimensional ...
Here I had a plan to post in September almost the same way I did in May, June and July, but business has been good (and I hope to not jinx it). There has been plenty of stuff going on, TFS 2010 left and right, MSDN Forums, SharePoint (all flavors and variations), BizTalk, SQL Server, Commerce Server, even Host Integration Server. And of course Hyper-V. A lot has been explored and equal in the realm of learning. From writing a Microsoft Official Course, giving self-publishing a try, creating some ...
I just posted details of 2 weeks of FREE training in October delivered via Live Meeting but we also recognise that some folks prefer classroom based training. Hence we have scheduled four two day workshops from September through to April. This two-day intensive instructor-led workshop provides delegates with an early opportunity to gain insight into the nature and benefits of the Windows Azure Platform. Delivered through workshop style presentations and hands-on lab exercises, the workshop will focus ...
Back in May and June I jointly run a highly successful (IMVHO) training programme on the Windows Azure Platform over a six week period for UK developers (Check out some stats/background). We have been discussing how we can take that format forward and I am pleased to say we have our first “spin off”. Namely the “Windows Azure Platform – Accelerated Virtual Training Workshop” which will take place in October. Yippeee. The training will be delivered over a two week period and combines instructor led ...
This is a quick post … after a lot of challenges with a recent deployment of BizTalk Server 2009, it is important to keep the following very much in mind. BizTalk Server 2009 and SQL Server 2008 R2 are not the best match, work with SQL Server 2008 with SP1. .NET 4.0 has the ability of breaking a not yet configured BizTalk deployment. Where? Enterprise SSO configuration will refuse to talk to the SSODB (mind you, the process will create the DB). There are fixes for this last one, just make sure you ...
August for some reason has been the busiest month I recall in a while. It has had a good doze of the products I love to work with, and it has given me the opportunity to get into one more, Azure. There has been BizTalk Server, SharePoint, SQL Server and Team Foundation Server and the surrounding tools. But I have been enjoying working with Azure. It’s a nice complexity full of good stuff (so far). In working with a client’s deployment the task came to needing to monitor the implementation. And since ...
The C# driver for MongoDb works with plain documents. Unfortunately, we don’t live in a document oriented world. Our world is more of an object oriented. There are numerous ways of converting the object structure into documents and I have blogged about this before. If you are interested here is an article which takes about ToDocument() method which can be used to convert objects to documents. Implementing Business Object to Documents Converter While making these conversions I thought that maybe I ...
I’m not pretty sure how many users are using the standard SQL Server Management Studio (SSMS) 2008 R2 to manage your SQL Azure database. I was one of them until I found the Houston project provided by Microsoft in its SQL Azure Labs. SQL Azure Labs is a place where we can try the latest CTP features of the SQL Azure. They might not be included in the production SQL Azure but I think most of them will be launched in the future. So it’s a good place for us to play with the newest stuff of SQL Azure. ...
SSMS Tools Pack is an add-in for Microsoft SQL Server Management Studio (SSMS) 2005, 2008, 2008 R2 and their respective Express versions. It contains a few upgrades to the SSMS IDE that I thought were missing. The current features include: •SQL Snippets •Window Connection Coloring •Query Execution History and Current Window History •Format SQL •Search Table, View or Database Data •Run one script on multiple databases •Copy execution plan bitmaps to clipboard or file •Search Results in Grid Mode •Generate ...
Just had a SQL Server 2005 database completely becoming unavailable after the drive on which its files were residing on completely ran out of space (thanks god in development). Freeing some space turned out to be a more or less strait-forward step. Now the recovery stage. Interestingly, out of a dozen databases (all in SQL 2000 compatibility mode) only one became affected. When I started to figure out what is wrong I checked the SQL Server log first and could see that another database’s log file ...
A few weeks ago my local TFS server stopped responding to Visual Studio because of this error: “TFS Service not available: HTTP Error 503”. So this morning while I was waiting for the kids to finish getting ready for school I uninstalled (yes, I lost my existing repository) and started with scorched earth. I received a new error during this installation: TF254043. Here’s a link to a post that fixes a few problems if you are upgrading, using SQL R2, or just can’t get Basic to run the verifications ...
This summer Inmeta ASA, a leading Norwegian IT company, bought Osiris Data. It means we’re now more than 150 consultants, up from 30 as we were. It means a lot for us, as we now can take on larger projects, more projects and with even more colleagues we will have better competency on more areas. It is also very exciting to be in a larger company, be “exposed” to more projects and more opportunities. Osiris Data was founded late autumn 1996, and started operation in January 1997, with 3 people. The ...
This past Wednesday, Beta 1 of Visual Studio LightSwitch (VSLS) was be made available to MSDN Subscribers. On Monday, it will be made available to the general public, at http://www.msdn.com/lightsw... Even in advance of Monday, that site is already making useful content available. Specifically, a Channel 9 video called “Visual Studio LightSwitch - Beyond The Basics” is well worth the viewing time. In it, Beth Massi (Program Manager on the Visual Studio Community Team) interviews Joe Binder (a Program ...
The road to learning is such an awesome thing! Yesterday, while browsing the MSDN Forums, I came across some people having frustration with SQL Server Express, Visual Web Developer 2010 and the Web Installer. The Issue After installation, if you create a New Website with VWD 2010, follow the steps below: Access the Web Site Administration Tool (Solution Explorer Toolbar) Click on Provider Configuration (Once the Web Site Admin Tool opens) Click on Select a single provider for all site management ...
On Tuesday August 18th, the first publicly available beta for the Microsoft Lightswitch development tool was posted on MSDN. For more information about this Silverlight application generator addition to Visual Studio 2010 visit: http://msdn.microsoft.com/e... Because it is still a beta I installed the 500mb ISO on a Windows 7 virtual pc VM which already had Visual Studio 2010. I had not spun up this VM for over 4 months so there were LOTS of updates to apply first. Although ...
TechEd 2010 Australia is approaching at a rapid pace and this year I have a speaking position. I will be talking on the topic of "PowerPivot: How, Why & When" doing some contrasting between PowerPivot and SSAS. And giving my opinions on where PowerPivot should be positioned in the Microsoft BI landscape. This will be happening at 3.30pm next Thursday. Even if you don't manage to catch my talk you should be able to find me hanging around the SQL Server area in the exhibition hall ...
Long Island Expressway...painless dentistry...dry wine...educational television. Inventing oxymorons like these is a wonderful party game; what others can we come up with today? How about: airline food...random order...House Ethics Committee...Service-oriented business intelligence.... That last phrase does seem like an oxymoron, at first glance. Service-Oriented Architecture (SOA) and Business Intelligence (BI) appear to be very different animals in enterprise architecture: Their purposes are very ...
I needed to dynamically configure log4net – outside of the web.config file. Here is my solution: 1. All that configuration of log4net in web.config? Forget it. 2. Create a separate log4net.config file (name it whatever you want), with the usual configuration content in it defining whatever appenders you want. For example if you want a rolling file log: <log4net> <appender name="RollingLogFileAppender" type="log4net.Appender.Roll... <param name="File" value="C:\\Temp\\mylog.txt" ...
In this blog and in my column, I’ve written a lot lately about new technologies from Microsoft that seek to make software development easier. Technologies like ASP.NET Web Pages, Razor and WebMatrix, Access Web Databases and Visual Studio LightSwitch. Each of these technologies, I believe, is bringing much needed accessibility to programming on the Microsoft platform. I’ve also written about Windows Phone 7 which, despite extreme skepticism in the press and analyst communities, has the potential ...
Did you know that when you connect to SQL Azure, a KERBEROS authentication is performed? However, when using SQL Server Management Studio, or any other client, you are forced to use a SQL authentication mechanism. While I was digging in the system tables, I realized that my SQL Azure connection was being reported as a KERBEROS authenticated connection. If you run this statement on your SQL Azure database... select session_id, auth_scheme from sys.dm_exec_connections ... this is what you get: session_id ...
When I was in school my instructor introduced me to relational databases. I mostly programmed in Oracle learning different types of JOINS and T-SQL statements. It was forbidden to talk about any other type database. Now, fast forward few years and everyone is talking about Document Databases. The NOSQL movement is all about non-relational databases. The word NOSQL might seems a little harsh if you are a DBA but the reality it just means that there are options other than relational databases. Think ...
We’re coming down to the wire here for SQL Saturday #28! We’ve got nearly 600 registered and more are coming in each day! If you haven’t yet registered for this event please do so. This is an opportunity to learn from some very smart folks on a variety of topics that range from SQL Server, BI, Sharepoint to .NET. Great time for making connections, expanding your skillset and helping mold our professions for a better future. Stop by the User Group booth and say hello while you’re there! http://www.sqlsaturday.com/... ...
En el artículo anterior se definieron los conceptos de la Nube y Cloud Computing, y se repasó rápidamente la evolución de tecnologías que favorecieron el surgimiento de dicho paradigma. En el presente artículo se definirán los diferentes conceptos “*aaS” relacionados con el concepto de cloud computing (SaaS, PaaS, IaaS, etc.). SaaS digamos que ya es un término hasta cierto punto conocido, pero ¿y los demás? Eso es lo que se aclarará en este artículo. Los servicios de computación en la Nube, así como ...
[Source: http://geekswithblogs.net/E... In my previous post, Cloud Services and Command-Query Separation: Part 2, I walked through a sample Command-Query Separated service bus solution using readily available cloud services for communication. In this one, I'll look at some of the implications of shifting systems integration to the cloud, compared to an on-premise ESB. The focus here is mainly on Amazon Web Services, but I'll cover Azure with a dedicated sample project. Cost & Non-Functional ...
I came across SharpSvn when trying to find a .NET API that I could use to do some tasks against Subversion. I was building a tool where I needed to pull a list of SQL files that have changed between revisions. Well, pretty much, the documentation is non-existent. In order to get a grasp of SharpSvn, I first had to realize that the API was not designed to be a quick-help utility. Instead, its API is very open, leaving it up to the consuming developer to create that "utility". First, I created an instance ...
Hey, Windows Azure and SQL Azure is free for one month. Unfortunately, its only for US Developers. But anyways, good news for US folks though. Also Microsoft is offering free phone, chat and email support through their Front Runner for Windows Azure Program. Windows Azure One Month Pass USA. Happy Azuring..... -Vishal Mody ...

Came across this excellent demos and HOLS here  for SQL Server 2008 R2
Enjoy

Ever need to parse SQL Syntax using .NET without actually executing the SQL? Pretty sweet because you can actually do this with built in sql server options. Works out pretty well. Executing a statement with a syntax error, referencing an object that doesn’t exist, a stored procedure with parameters that has no parameters, etc produces a SqlException with an appropriate error message. 1: static void ParseQuery(string sql) 2: { 3: SqlConnection connection = new SqlConnection("some_connect... ...
There are times when we only want to the unique records from a table where there are many records that have the same value. In this example, I have a table that stores all the coating weight footage measurements for a strip of steel as it moves thru the zinc pot. The primary key of this table is composed of the four columns: Column Type WTAG NUMBER(7,0) MULT_NUM NUMBER(2,0) CUT_NUM NUMBER(3,0) FT_CWG NUMBER(6,0) so, as one can see, from the primary key definition, a single coil, as identified by ...

We recently had to open a ticket with MS regarding the creation of workflows when using Infopath.  Basically what would happen is that the connection to the SQL box was so slow that the XML was not getting created on the workflow.  We're running IE8 with Win 7, X64. 

THE SOLUTION: Go into IE -> choose tools -> connections -> LAN settings and uncheck the auto detect option. 

Hope that helps someone.

At VSLive today, I had the pleasure of introducing Microsoft Corporate VP Jason Zander. And he had the pleasure of introducing Visual Studio LightSwitch. Pleasure is a theme here, because the product, to me at least, looks great. LightSwitch is a .NET based environment, hosted in Visual Studio, that allows developers to build business apps. Quickly. It harkens back, with pride, to tools of old, like VB6 and FoxPro, that made data, and data maintenance UIs, first class citizens. These tools also treated ...
Today at VSLive! we announced Visual Studio LightSwitch (link not quite up yet). LightSwitch is intended to be the simplest way to build business applications for the desktop and cloud. It provides the tools to rapidly develop professional applications from pre-built templates in a simplified development experience. It is intended to be used by professional developers. Top level features: Applications are built in Silverlight Pre-built templates Support for SQL Server, Sharepoint and SQL Azure Applications ...
Recently I was tasked with the responsibility of purging database from one of our SQL 2000 databases. One of the test cases is to use a copy of a database that is a small production database and delete all of the data contained within. After the delete is executed then I can review the data tables and see what is left over or was skipped after the delete script runs. Looking at the properties of hundreds of tables in Enterprise Manager seemed pretty tedious. After a quick query to Bing I was able ...
Introduction Let’s pretend you are being interviewed for the DBA or T-SQL Programmer job and are asked a question like this: What is the precision of the GETDATE() and/or SYSDATETIME() function? If your answer is …: Well, GETDATE() function returns DATETIME data type so the precision is 3.33 ms, the SYSDATETIME() function returns DATETIME2 data type so the precision is 100 ns. …read on to find out if you are correct. Testing precision of GETDATE()… In order to find out what the correct answer should ...
Security Basics and ASP.NET Support; An Overview of Forms Authentication; Forms Authentication Configuration and Advanced Topics; Creating the Membership Schema in SQL ServerCreating User Accounts; Validating User Credentials Against the Membership Store; User-Based Authorization; Storing Additional User Information; Creating and Managing Roles; Assigning Roles to Users; Role-Based Authorization; Building an Interface to Select One User Account from Many Recovering and Changing Passwords; Unlocking ...
CTP1 of Microsoft® Project Code-Named “Houston” is now available. This is a lightweight and easy to use database management tool for SQL Azure databases. It enables you to swiftly develop, deploy, and manage data-driven applications in the cloud. Project “Houston” provides a web-based database management tool for basic database management tasks like authoring and executing queries, designing and editing a database schema, and editing table data. All implemented in Silverlight. Getting Started For ...
One of the cool features of the software my company builds is the ability to create "ad-hoc queries." The concept is simple but powerful: developers build SQL views for important data, which are available to users via a visual interface. After the user has visually built a query for the exact data she needs, our software generates a SQL language query that uses one or more of the views to extract/filter the requested data. The query can be saved with a name, an owner, security permissions, and other ...
El primer paso a completar es el tener una cuenta en Azure, hay que tener muy claro que esto representa algo que va a significar en costo y cargos por utilizar los servicios. Lo que haremos es ir a www.azure.com . Veremos una página como esta El siguiente paso es acceder a la cuenta de la siguiente manera, haciendo click en Account llegamos a la siguiente página… 1. Si ya se tiene cuenta en alguno de los servicios, pues se hace click en las opciones de la derecha. 2. Si no se tiene cuenta, entonces ...
Introduction On many BizTalk projects you have to deal with managing mapping of reference data. A number of times in the past I've spoken about the features in BizTalk for mapping reference data however they do have some limitations which mean that it is very common for a project to implement their own tables in a custom database to hold mapping reference data. While this is entirely valid you often end up with the pain of how do you manage the reference data mappings. One of the simplest ways is ...
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; ...
I recently received an email from a self-described “old school” developer who had attended one of our Visual FoxPro classes from a number of years back (2001?). He had some questions about working with SQL Server 2008 and T-SQL. He asked about a number of built in VFP/xBase functions that don’t have a counterpart in T-SQL, specifically some that deal with dates and strings. I too went through that migration waaaaay back when and have since created some UDFs that reproduce some familiar and very useful ...
A while back it was clear: Roses are red, violets are blue … if you are a dev you use Visual Studio. Now: Roses are blue, violets can be red … if you do SharePoint,Visual Studio is the right tool for you. I am not a poet, nor do I pretend to be one on TV. But I have invested time in fine tuning virtual machines and physical deployments in figuring out what goes where and what is needed. We see dependencies of every type, in every place and every product pretty much. If you are doing SQL Server 2008 ...
Today I put out a new release for PowerSSAS. This release adds the following new cmdlets: backup-ASDatabase clear-ASCache get-ASConnection get-ASRole restore-ASDatabase It also includes a Powershell v2 .psd1 module file and includes the option to just download a zip file which can be copied into a folder your modules folder. So you can now install PowerSSAS without needing to have admin privileges. There are instructions on installing PowerSSAS as a v2 module here. I have also done some preliminary ...