sqlposts.blogspot.com
Monika's SQL Corner: How to enable TDS parser to display TDS frames when SQLServer is listening on port other than default 1433
http://sqlposts.blogspot.com/2010/10/how-to-enable-tds-parser-to-display-tds_17.html
Sunday, October 17, 2010. How to enable TDS parser to display TDS frames when SQLServer is listening on port other than default 1433. If you try to view a netmon trace in Netmon 3.4, you will see TDS traffic is nicely parsed for you. You will see a display similar to this: The parsing works nicely because SQL. Server is listening on default tcp port 1433. But, if your SQL. Source: blogs.msdn.com. Security Auditing a Database. Source: blogs.lessthandot.com. Developer group at Microsoft]. Server 2005 or SQL.
sqlposts.blogspot.com
Monika's SQL Corner: Tools of the Trade: Part II – The Repro
http://sqlposts.blogspot.com/2010/10/tools-of-trade-part-ii-repro_17.html
Sunday, October 17, 2010. Tools of the Trade: Part II – The Repro. In this series of posts, we’re going to take a look at some of the tools we at Microsoft Developer Support - Database commonly use, how to use them, and the types of issues they can be used to resolve. This post might seem like a bit of a stretch. For one thing, it’s not about a SQL. Related tool. That’s not such a big deal – there are plenty of tools that we use that have applications beyond SQL. 2005 SP2 is available now! Server 2008 ma...
sqlposts.blogspot.com
Monika's SQL Corner: Newly closed Connect items auger well for SSIS in Denali
http://sqlposts.blogspot.com/2010/10/newly-closed-connect-items-auger-well.html
Sunday, October 17, 2010. Newly closed Connect items auger well for SSIS in Denali. The provision of more execution metadata for logging purposes gives me hope that the next version of SSIS will have a much better story around logging. Hopefully we won't have to wait long to find out. @Jamiet. Source: feedproxy.google.com. The History of SQL. A new blogpost has been posted by Ted Krueger (onpnt) on Oct 11, 2010 in category Database Administration. Source: blogs.lessthandot.com. Running Total: CTE wins.
sqlposts.blogspot.com
Monika's SQL Corner: SQL Null: Grouping and sorting
http://sqlposts.blogspot.com/2010/10/sql-null-grouping-and-sorting_1700.html
Sunday, October 17, 2010. SQL Null: Grouping and sorting. Server defines all Null markers as being unequal to one another, a special definition was required in order to group by Nulls together when performing certain operations. SQL. Defines “any two values that are equal to one another, or any two Nulls”, as “not distinct”. This definition of not distinct allows SQL. Server handles the default sort order for Nulls. Source: brian.chipsofttech.com. Source: jerrytech.blogspot.com. Setting up database unit ...
sqlposts.blogspot.com
Monika's SQL Corner: tSQL Regular Expressions
http://sqlposts.blogspot.com/2010/10/tsql-regular-expressions.html
Sunday, October 17, 2010. Source: jerrytech.blogspot.com. Step by step N-tier configuration of Sync services for ADO.NET 2.0. Server 2008 or Visual studio 2008, SP1. You can also download it from http:/ www.microsoft.com/downloads/details.aspx? Server Compact 3.5 Service Pack 1 on this client machine if it is already not there. SQL. Server Compact is available in three ways: - Integrated with SQL. Server other than SQL. Server Compact to act as the server database. If you like to you can use SQL. Stateme...
sqlposts.blogspot.com
Monika's SQL Corner: Some thoughts on Visual Studio database references and how they should be used for SQL Server BI
http://sqlposts.blogspot.com/2010/10/some-thoughts-on-visual-studio-database.html
Sunday, October 17, 2010. Some thoughts on Visual Studio database references and how they should be used for SQL Server BI. Server Integration Services(SSIS), Analysis Services (SSAS) and Reporting Services (SSRS) projects. After all reports, packages and data source views are rife with references to database objects – why shouldn’t we be able to have design-time dependency checking in our BI projects the same way that database and .Net developers do? Source: feedproxy.google.com. The History of SQL.
sqlposts.blogspot.com
Monika's SQL Corner: SQL Null: Grouping and sorting
http://sqlposts.blogspot.com/2010/10/sql-null-grouping-and-sorting_3884.html
Sunday, October 17, 2010. SQL Null: Grouping and sorting. Server defines all Null markers as being unequal to one another, a special definition was required in order to group by Nulls together when performing certain operations. SQL. Defines “any two values that are equal to one another, or any two Nulls”, as “not distinct”. This definition of not distinct allows SQL. Server handles the default sort order for Nulls. Tuesday #11 Misconceptions – Enable AWE on 64bit SQL. Security Auditing a Database. To in...
sqlposts.blogspot.com
Monika's SQL Corner: Wisconsin SQL Server User Group
http://sqlposts.blogspot.com/2010/10/wisconsin-sql-server-user-group.html
Sunday, October 17, 2010. Wisconsin SQL Server User Group. A new blogpost has been posted by Ted Krueger (onpnt) on Oct 11, 2010 in category Database Administration. Source: blogs.lessthandot.com. Concatenate strings “1, 2, 3” and select results, too. Source: jerrytech.blogspot.com. Agent jobs and the owner of those jobs. A new article has been posted in the wiki. Source: wiki.lessthandot.com. Source: jerrytech.blogspot.com. SSIS runs in BIDS but not with SQL. Source: blogs.lessthandot.com. To group and ...
sqlposts.blogspot.com
Monika's SQL Corner: My SQLBits presentation this coming Friday – SSIS Performance Tuning
http://sqlposts.blogspot.com/2010/10/my-sqlbits-presentation-this-coming_17.html
Sunday, October 17, 2010. My SQLBits presentation this coming Friday – SSIS Performance Tuning. Source: feedproxy.google.com. Source: jerrytech.blogspot.com. Take your script library with you [T- SQL. Professionals I’m sure many of you build up a library of SQL. Scripts that you take from project to project, right? Script library. Here’s a screenshot of the Windows Live Mesh client: Notice that I have a folder called “Personal SQL. 2005 and above Sql. ClrToolkit – a suite of useful SQL. UPDATE 2: Jezza10...
sqlposts.blogspot.com
Monika's SQL Corner: After Installation of .NET Framework 3.5 SP1 (or .Net framework 2.0 SP2) , SSIS packages using ODBC 3rd party drivers may fail
http://sqlposts.blogspot.com/2010/10/after-installation-of-net-framework-35_17.html
Sunday, October 17, 2010. After Installation of .NET Framework 3.5 SP1 (or .Net framework 2.0 SP2) , SSIS packages using ODBC 3rd party drivers may fail. GetData with a BufferLength argument of 0 for variable width data types. Certain ODBC drivers are not compatible with this pattern. For more information on this function and its arguments, see: SQL. Source: blogs.msdn.com. Commonly used 32-bit CPU registers and their purpose. Source: blogs.msdn.com. Source: feedproxy.google.com. Server Management Studi...