tag:blogger.com,1999:blog-105755962024-02-03T10:18:20.972+01:00snaps & snippetsSee "<a href="http://milambda.blogspot.com/2005/02/first-one.html">The First One</a>"Unknownnoreply@blogger.comBlogger90125tag:blogger.com,1999:blog-10575596.post-45214847695263843092014-02-27T18:35:00.001+01:002014-02-27T18:35:21.654+01:00SQL Server Integration Services, Data Type Mapping SQL Server Integration Services (SSIS) utilize several type systems – some depending on the different data providers supported by the SSIS, some depending on the environment where the service is used, etc. When designing SSIS packages, especially in heterogeneous environments, where different data management platforms and tools are used, appropriate data type mapping is highly critical &Unknownnoreply@blogger.com8tag:blogger.com,1999:blog-10575596.post-36883414728573544232013-03-20T16:02:00.000+01:002013-03-20T16:02:01.402+01:00SQL Server 2012 FileTables, Text Files and Full-text Search In July 2012, fellow SolidQ Mentor and Microsoft MVP, Davide Mauri (@mauridb), discovered an unexpected behavior of the SQL Server 2012 Full-text Search (FTS), and/or Statistical Semantic Search (SSS), while indexing documents placed in a SQL Server 2012 FileTable as TXT files. Instead of the language set in the definition of the full-text index (see CREATE FULLTEXT INDEX in SQL Server Books Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-48188514934703751422013-03-19T00:56:00.001+01:002013-03-19T00:56:54.002+01:00SSIS 2012 Bug with Windows Group Permissions In October 2012 a bug was discovered in SQL Server 2012 Integration Services, specifically in the SSISDB Catalog, where permissions assigned to an SSISDB user mapped to a Windows Group login are not determined correctly at run time. The SSISDB Catalog security model extends the native SQL Server security model to allow the permissions to be managed at various SSISDB object levels (e.g. Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-35757204964956135272012-10-29T18:10:00.001+01:002012-10-29T18:11:41.175+01:00SSISDB Catalog Deep Dive at Bleeding Edge 2012Between October 22nd and 24th 2012 the fifth installment of the Bleeding Edge conference took place in Laško, Slovenia. Considering the responses from the attendees as well as the speakers, the conference was once again a great success.Congratulations to the organizers, and big thanks to the attendees! Special thanks go to the companies, who decided to send their developers and Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-9679152577305470532012-07-24T14:25:00.000+02:002020-04-05T01:04:10.251+02:00SQL Server 2012: Migrating BLOBs to FILETABLEs (MVP Mondays)I have been invited by Melissa Travers to participate in the MVP Monday Series at the Microsoft MVP Award Program Blog.The subject of my initial article is the migration of large data into FileTables, a new large data management feature introduced in Microsoft SQL Server 2012.You can find the article (including sample code) at the following address:http://blogs.msdn.com/b/mvpawardprogram/archive/Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-8408885930977447402012-03-30T03:00:00.002+02:002012-03-30T03:05:22.441+02:00XML Query Composition in PracticeXML composition using XML Query is not what you might call a popular subject, not even a frequently discussed one; well, at least as far as SQL Server is concerned. In this blog, I have discussed XML retrieval on numerous occasions, I have also touched SQL Server XML performance characteristics, but XML composition has so far been stuck on the back burner. Until now, that is.
The subject of Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-2533638803167867462012-03-23T20:11:00.001+01:002012-03-23T20:12:50.912+01:00SQL Server 2012 RTMEarlier this month SQL Server 2012 RTM was announced, and the evaluation is now available for download:
Microsoft SQL Server 2012 Evaluation.
The build number for the RTM is 11.0.2100.60.
Related downloads are also available:
Books Online for SQL Server 2012 – product documentation is available online, and can also be installed locally. Books Online are not Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-7787005387401707872011-06-01T11:46:00.001+02:002011-06-01T11:47:41.914+02:00XPath ID for People Avoiding PubsI discussed the ID XPath function in a recent post. I composed the data samples used in that post from the data available in the pubs sample database. Since this particular database may not be a very popular commodity these days, I've also prepared a "pubs-free" alternative – using the same data as before, but with fewer obstacles.
The sample consists of two scripts showcasing Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-2602865650942429572011-05-09T15:29:00.013+02:002011-06-01T11:57:47.428+02:00SQL Server: The XPath ID FunctionXML provides a simple and efficient way of storing relational data, especially for the purposes of transporting it from one RDBMS to another. Besides the "natural" technique, where the structure of the XML document is used to represent the relationships, XML Schema also provides three special data types that can be used to define the relationships inside an XML document. I've already Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-10575596.post-58547562693922133542011-04-05T00:09:00.001+02:002011-04-05T00:11:09.669+02:00SQL Server Integration Services, Execute SQL with Complex ParametersIf you're familiar with SQL Server Integration Services (SSIS) then you've probably, at one time or another, run into problems with the integration bit – however weird that may sound. I can understand the fact that SSIS is supposed to be generic and universal and platform independent, and therefore not favor a particular DBMS – not even the one that it's a part of. Nonetheless, for Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-10575596.post-71690794727334257672010-03-04T21:50:00.002+01:002010-03-04T21:52:27.788+01:00Cannot open user default database? Login failed?Assigning a default database to every server principal (login) is good practice, no doubt. Just think of the last time someone in your organization created a user object in master by mistake. Generally, the most appropriate database to set as the default for a user is the database they will most likely access when performing their work, and for most cases that would be a user database (rather Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-27953299820561445712010-01-03T19:38:00.002+01:002010-01-03T20:37:07.188+01:00What Permissions Does a Principal Have?SQL Server Management Studio provides several ways of checking which permissions have been granted (or denied) to whom and on what objects. This is achievable on different levels within the securables hierarchy:
Server-level permissions, per principal: on the Permissions page of the Server Properties window (accessible through the View menu when the instance node is selected in the ObjectUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-38156745309035398672009-11-20T21:17:00.001+01:002009-11-20T21:18:53.418+01:00SQL Server MVP Deep DivesEarlier this month, at the PASS 2009 Summit, a very special event took place – the SQL Server MVP Deep Dives book launch. As the title suggests, this is no ordinary SQL Server book, for several reasons:
It was written by 53 MVPs;
100 percent of authors' royalties have been donated to support War Child International, a network of independent organizations, working Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-13139620366436547892009-04-10T18:54:00.002+02:002009-04-10T18:57:12.405+02:00[snap] Pending File Rename Operations?I will never understand why some software/hardware vendors fail (forget?) to clean up the Windows registry after they've... well, fondled with it for reasons known only to them, such as during software installation or updates.
When installing SQL Server – the release or a service pack – on a machine where software from one of the aforementioned vendors has recently been installed Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-26521008423791671012009-04-09T10:06:00.002+02:002009-04-09T10:07:06.637+02:00SQL Server 2008 Service Pack 1SQL Server 2008 Service Pack 1 has been released on April 7th 2009, bringing a few improvements to the setup process – on top of several important fixes.
Be sure to review the release notes before attempting installation.
The files can be downloaded from the following site:
SQL Server 2008 Service Pack 1.
The list of bugs fixed in SP1:
KB 968369.
MLUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-24759155223936723912009-03-08T20:33:00.003+01:002009-04-10T19:31:39.729+02:00SQL Server 2008 XPath FunctionsThe 2008 version of SQL Server has not introduced as many changes to its XPath implementation as one might have expected; nonetheless, two additional XPath functions have been added.
In fact, I'm very sure many of us have missed both of them ever since SQL Server 2005:
lower-case() – returns the text of the target node in lower case; and
upper-case() – returns the text Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-73955790623380666192009-02-03T12:36:00.001+01:002009-02-03T12:37:25.177+01:00SQL Server 2008 Books Online Update (January 2009)The January 2009 update of SQL Server 2008 Books Online has been released last Friday. The installation file is available for download:
Microsoft SQL Server 2008 Books Online (January 2009).
An update of the sample databases is scheduled for spring, and by the looks of things that's still very far away. ;)
Anyway, the samples are available at CodePlex:
SQL Server 2008 Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-36061306778607066082008-12-31T21:17:00.002+01:002008-12-31T21:50:27.332+01:002008 May Not Be the Last for Planet EarthWhat do you think?
Have a good one!
ML
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-5482110787767413742008-12-21T18:13:00.004+01:002008-12-21T18:15:59.614+01:00Sparse Columns and Filtered IndexesAt the December meeting of SLODUG, the Slovenian Developers User Group, I've presented two new functionalities introduced with SQL Server 2008:
Sparse Columns – a new (or, at least, an improved) way of storing data in nillable columns so that non-existent data takes up virtually no space in the database.
Well, to be honest, storage usage *is* affected (as the maximum Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-75875022920216737022008-12-21T18:09:00.002+01:002008-12-21T18:12:26.625+01:00Some Old NewsThis may be old news, but I haven't said anything about this so far, so this may not be old news to everyone. ;)
SQL Server 2005 Service Pack 3
SQL Server 2005 SP3 has been released on December 15th 2008. The files (elevating the full version number to 9.00.4035) are available for download:
Microsoft SQL Server 2005 Service Pack 3;
Microsoft SQL Server 2005 Express Edition Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-70718656577380361442008-10-01T09:50:00.004+02:002008-10-01T09:53:28.592+02:00SQL Server 2008 Books Online Update (August 2008)An update to SQL Server 2008 Books Online has just been published yesterday:
Microsoft SQL Server 2008 Books Online (August 2008).
MLUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-39324040398946138282008-08-26T11:53:00.001+02:002008-08-26T11:54:27.601+02:00SQL Server 2008 Express with Advanced ServicesThe advanced edition of SQL Server 2008 Express is now available for download. As was the case with version 2005 when this edition was first introduced, the Advanced Services include (in addition to the Database Engine, of course):
SQL Server Management Studio Basic (formerly: Express);
Full-text Search; and
SQL Server Reporting Services (limited to local reporting).
You Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-31555942184830928292008-08-08T18:56:00.004+02:002008-08-09T14:23:57.142+02:00SQL Server 2008 RTMI'm sure you know by now that SQL Server 2008 has RTMed about two days ago and is already available for download to MSDN/TechNet subscribers.
There are additional free downloads that you might also be interested in:
Microsoft SQL Server 2008 Evaluation Edition;
Microsoft SQL Server 2008 Upgrade Advisor;
Microsoft SQL Server 2008 Feature Pack, August 2008;
Microsoft SQL Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-10575596.post-21396166801846459462008-06-13T16:08:00.002+02:002008-06-13T16:10:44.661+02:00SQL Server 2008 (RC0), FILESTREAM changesAt this year's Microsoft NT Conference in Portorož fellow MVP Andrej Tozon and I have presented a workshop on designing solutions with Visual Studio 2008 and SQL Server 2008 using the Windows Presentation Foundation and a few new SQL Server 2008 features. Andrej has blogged about this last month and has made all the workshop files available on his site.
You might also already know that SQL Unknownnoreply@blogger.com3tag:blogger.com,1999:blog-10575596.post-72927317283329860702008-05-07T16:08:00.005+02:002008-05-07T16:13:58.771+02:00SQL Server 2008 Scoped SearchThis may be old news, but it's also the kind of "old news" that's actually becoming more and more relevant these days. ;)
More than a month ago the Microsoft SQL Server documentation team have announced a new Live Search Macro:
The SQL Server 2008 Books Online Scoped Search macro.
Those of you who've found the 'old' one useful, must have been anticipating the 'new' one.
Unknownnoreply@blogger.com0