DotNetShoutout

Data

5
Shouts

Shout it

SQL-Articles - SQL Server Joins

published 1221 days, 2 hours, 19 minutes ago posted by

sqlarticles 1221 days, 11 hours, 42 minutes ago

SQL Server joins are required to retrieve data from one or more tables to get a single result set. Joins are needed when Normalization enforced in design. When you normalize the data you be reducing redundancy in data by placing data in different tables and also you will be creating relationship between the tables. With the help of these relationship you will be retrieved... (more)

category: Data | clicked: 0 | comment | | source: www.sql-articles.com

tags: sql joins, TSQL, joins

5
Shouts

Shout it

Refresh intellisense local cache in Sql Server 2008

published 1221 days, 2 hours, 19 minutes ago posted by

Praveen 1221 days, 7 hours, 19 minutes ago

Everyone knows that Sql server 2008 has an excellent feature for supporting the intellisense. This will surely fasten the development. Last week, I have created 3 tables in my Sql server 2008 and when I try to write the stored procedure based on those tables, surprisingly they weren't shown in the intellisense any more. I thought initially it's a bug in Sql Server 2008. Lately after done some research and found that we need to refresh the cache for intellisense to shown up everything correct. Please find... (more)

category: Data | clicked: 0 | comment | | source: praveenbattula.blogspot.com

tags: SQL Server 2008, Intellisense

5
Shouts

Shout it

Sql Server reporting services and Forms authentication – Part 3 – Linking aspnetdb to report server

published 1221 days, 2 hours, 19 minutes ago posted by

Praveen 1221 days, 7 hours, 15 minutes ago

I think, you have read my previous two posts related to implementing forms authentication in report server. Sql server reporting server and forms authentication – Part 1 – Understanding the concept. Sql Server reporting server an forms authentication – Part 2 – How to implement. I just followed Russell’s article to link sql server report server to aspnetdb. So, I prefer to redirect my users to the same post. I don't want to repeat the whole story here again. So, please go here and continue your readin... (more)

category: Data | clicked: 3 | comment | | source: praveenbattula.blogspot.com

tags: Authentication, SSRS, SQL Server Reporting Services

9
Shouts

Shout it

Code Capers | The Missing LINQ - Beware of Generated Code

published 1222 days, 47 minutes ago posted by

mceranski 1224 days, 20 hours, 54 minutes ago

LINQ (Language Integrated Query) to SQL is a great tool because it allows developers to concentrate on business problems instead of worrying about writing SQL. Unfortunately, generated code typically comes with a catch. My general rule of thumb is that "I never trust any tools that have a wizard or generate code". After all, everytime you release code into production you are putting your reputation on the line. Therefore, don't you think it is important to know what your code is really doing under the co... (more)

category: Data | clicked: 1 | comment | | source: www.codecapers.com

tags: Performance, Linq

7
Shouts

Shout it

Report viewer control authentication – Part 2 – Forms Authentication

published 1223 days, 2 hours, 14 minutes ago posted by

Praveen 1223 days, 16 hours, 53 minutes ago

If the reporting services configured to use forms authentication and you need to show the reports in the custom developed applications then the need of processing authentication the report viewer control through the code. Report viewer control authentication using windows authentication is described in the part 1 here. Now, we will discuss the authenticating forms authentication through C# code. If we are are developing windows application and want to use report viewer control, then we need to impleme... (more)

category: Data | clicked: 10 | comment | | source: praveenbattula.blogspot.com

tags: Forms Authentication, C#, SSRS, Reports, SQL Server Reporting Services

11
Shouts

Shout it

Microsoft SQL Server Migration Assistant for MySQL v1.0 CTP1

published 1223 days, 2 hours, 14 minutes ago posted by

http://quachnguyen.myopenid.com/ 1225 days, 22 hours, 41 minutes ago

Microsoft has made available for download a free tool designed to streamline the migration of MySQL databases to SQL Server. At the start of this week, the company began offering customers a preview version of Microsoft SQL Server Migration Assistant. According to the software giant, the Community Technology Preview of SQL Server Migration Assistant (SSMA) for MySQL v1.0 integrates seamlessly with not only SQL Server 2005, but also SQL Server 2008 and even SQL Azure. The company underlines that the migra... (more)

category: Data | clicked: 1 | comment | | source: code2code.info

tags: SQL

9
Shouts

Shout it

Scheduling jobs in Sql server Express

published 1224 days, 6 minutes ago posted by

Praveen 1225 days, 17 hours, 20 minutes ago

I know, at some point you need this when you use sql express. Sql express is the limited edition of Sql server. So, it doesn't contain all the features. To schedule we need sql server agent service. But it comes only with sql server. So, creating jobs are not possible with sql express. So, is there any way? Yes. Today I found a nice article on it. And that is perfect. Take a look at it and let me know your ideas on it. http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express Hope you like... (more)

category: Data | clicked: 0 | comment | | source: praveenbattula.blogspot.com

tags: SQL Server, jobs, Scheduling, SQL Express

8
Shouts

Shout it

Data Formatting in sql server reporting services

published 1229 days, 53 minutes ago posted by

Praveen 1230 days, 23 hours, 43 minutes ago

In Sql server reporting services the formatting the data is pretty much simple as we have plenty of built in options available for percentage, numbers, decimal, currency etc. So, just them to data format and display the data as you want. Below are most commonly use format for the usual reports.c – Currencyd – Decimaln – Numberp – Percentage. If you want two decimal places in decimal number then in the format option [Text box properties -> format] then the format should be d2. In percentage if you want ... (more)

category: Data | clicked: 0 | comment | | source: praveenbattula.blogspot.com

tags: SQL Server, Formatting, Reports

7
Shouts

Shout it

SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2 « Journey to SQL Authority with Pinal Dave

published 1229 days, 53 minutes ago posted by

pinaldave 1230 days, 22 hours, 17 minutes ago

In my earlier post, I wrote about how one can use XML to convert table to string SQL SERVER – Comma Separated Values (CSV) from Table Column. The same article is also published on channel 9 SQLAuthority News – Featured on Channel 9. One of the very interesting points that was discussed on show was about the usage of function SUBSTRING. I found the following point very valid: SUBSTRING usage limits the length of the XML to be used. I have re-written the same function with function STUFF, and it removes a... (more)

category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: XML, SQL, SQLServer, pinaldave, SQLAuthority

11
Shouts

Shout it

Setting Up a Database For Integration Tests

published 1230 days, 32 minutes ago posted by

http://micahlmartin.myopenid.com/ 1232 days, 23 hours, 21 minutes ago

Warning There is a lot of code in this post. Nothing too crazy or fancy just a LOT of code. It's too much of a pain to create and upload a project file so I've just pasted in. If for some reason you are having trouble getting the code off the page just shoot me an email and I'll send it to you. Also, I'm using MSTest so if that bothers you then please move along.Purpose I've always avoided doing full integration tests because it's always such a pain to get a db setup and in working order each time you ... (more)

category: Data | clicked: 3 | 7 comments | | source: www.codingcontext.com

tags: integration tests, TDD

16
Shouts

Shout it

Innovation Showcase : Creating PHP CRUD Apps with SQL Server on-premise or in the Azure Cloud

published 1230 days, 32 minutes ago posted by

bobfamiliar 1231 days, 21 hours, 48 minutes ago

07 January 2010Creating PHP CRUD Apps with SQL Server on-premise or in the Azure Cloud The SQL CRUD Wizard for PHP is a sample .NET application that can be used to generate a simple "Create, Read, Update, Delete" PHP application from a Microsoft SQL Server database table. The generated PHP application supports paging, sorting and simple CSS customization. The project is open source and hosted on CodePlex. Details at the Interoperability@Microsoft site. Technorati Tags: Open Source,PHP,SQL Server,Wind... (more)

category: Data | clicked: 1 | comment | | source: blogs.msdn.com

tags: SQL Server, Windows Azure, SQL Azure, PHP

10
Shouts

Shout it

SQL-Articles - Merge Drop Slipstream Setup – SQL Server 2008

published 1231 days, 2 hours, 34 minutes ago posted by

sqlarticles 1233 days, 21 hours, 5 minutes ago

In my previous article we have discussed about Basic slipstream setup, now I’m going to write a article on Merged Drop slipstream setup. In this method you will be merging the service pack with the base setup prior to the installation there by altering the source or base setup files. The merged setup package can be reused multiple times and... (more)

category: Data | clicked: 1 | comment | | source: www.sql-articles.com

tags: SQL setup, slipstream

8
Shouts

Shout it

ADO.NET team blog : POCO Proxies Part 1

published 1234 days, 23 hours, 44 minutes ago posted by

ali62b 1236 days, 3 hours, 8 minutes ago

POCO Proxies Part 1Published 22 December 09 09:52 AM | dpblogs The Entity Framework (EF) in .NET 4.0 introduces the ability to interact with entities with persistence ignorance (POCOs). While this favors separation of concerns, it also means that the entities will do less because they cannot talk directly to the data access layer. Another new concept in EF 4.0 is the idea of dynamically generated proxies for such entities. Opting into proxies is an easy way to get additional capabilities like lazy lo... (more)

category: Data | clicked: 0 | comment | | source: blogs.msdn.com

tags: proxy, Entity Framework 4

8
Shouts

Shout it

Find tables with identity columns in Sybase ASE

published 1234 days, 23 hours, 44 minutes ago posted by

SybaseAddict 1236 days, 21 hours, 48 minutes ago

Quickly find out the database’s tables having identity columns: 1> select objectname(id) as "tablename",name as "columnname" 2> from syscolumns where status =128 3> go Enjoy (more)

category: Data | clicked: 0 | comment | | source: sybase-addict.com

6
Shouts

Shout it

List Server Reserved Words in Sybase ASE

published 1235 days, 23 hours, 26 minutes ago posted by

SybaseAddict 1236 days, 21 hours, 47 minutes ago

You just have to run a simple query in isql to find all the reserved words for Adaptive Server Enterprise and Sybase SQL Server. To list all reserved words for Adaptive Server Enterprise, log in to isql and run this query: 1> select name from spt_values where type = "W" 2> go The spt_values table is a look-up table in the master database that stores system values used by other server processes. (more)

category: Data | clicked: 0 | 1 comment | | source: sybase-addict.com

9
Shouts

Shout it

SSIS 2008 Flat File Source Issue

published 1237 days, 9 minutes ago posted by

MarlonRibunal 1240 days, 2 hours, 36 minutes ago

Ok, this might be my last post for this year, 2009. This is more of a note to myself than a blog post. Anyway, I want to document the issue that I have encountered and the solution that I have found through the help of Todd McDermid (Blog | Twitter) and Andy Leonard (Blog | Twitter), so that it might help those who might be in the same si... (more)

category: Data | clicked: 0 | comment | | source: dbalink.wordpress.com

tags: ssis bi sqlserver flatfile dts migration

10
Shouts

Shout it

Using NHibernate order-by attribute to sort names history

published 1240 days, 23 hours, 32 minutes ago posted by

gpeipman 1242 days, 20 hours, 12 minutes ago

I am writing application that besides other cool things lets users insert information about business contacts. My system is able to keep names history of contacts. In this posting I will show you how to use NHibernate mappings to keep names ordered logically. (more)

category: Data | clicked: 0 | comment | | source: weblogs.asp.net

tags: SORTING, NHibernate

7
Shouts

Shout it

How to get Sql server 2008 intellisense working for new schema changes

published 1248 days, 2 hours, 41 minutes ago posted by

kcherupa 1249 days, 1 hour, 25 minutes ago

The new feature "intellisense" added in sql server 2008 is making my life easier. And I am enjoying this feature a lot. But I noticed many times that when we make any changes to DB schema like creating / modifying database objects we don't notice the schema changes in intellisense in the same session. This made me too bad and many times I cursed Microsoft for this inclomplete feature. But after making some research on this, I have found the solution to get intellisense for new schema changes in current ... (more)

category: Data | clicked: 2 | 1 comment | | source: cherupally.blogspot.com

tags: Auto Fill, SQL Server 2008, Cache, Intellisense, management studio

10
Shouts

Shout it

Adding article to existing publication without generating a full snapshot

published 1248 days, 23 hours, 15 minutes ago posted by

sqlarticles 1251 days, 4 hours, 56 minutes ago

This SP can be used to add articles to the existing publication without starting snapshot for all the tables. When Snapshot is started it will create snapshot only for the newly added article to the publication (more)

category: Data | clicked: 0 | 1 comment | | source: www.sql-articles.com

tags: replication, scripts, sqlarticles

10
Shouts

Shout it

SQL-Articles - Monitoring Replication using Scripts(Version 1.0)

published 1248 days, 23 hours, 15 minutes ago posted by

sqlarticles 1251 days, 4 hours, 55 minutes ago

This script can be used to monitor replication using scripts instead of logging into the server and using replication monitor. It gives information on Transactional replication status. (more)

category: Data | clicked: 0 | comment | | source: www.sql-articles.com

tags: replication, scripts, sqlarticles

Welcome!

Data

SQL-Articles - SQL Server Joins

Refresh intellisense local cache in Sql Server 2008

Sql Server reporting services and Forms authentication – Part 3 – Linking aspnetdb to report server

Code Capers | The Missing LINQ - Beware of Generated Code

Report viewer control authentication – Part 2 – Forms Authentication

Microsoft SQL Server Migration Assistant for MySQL v1.0 CTP1

Scheduling jobs in Sql server Express

Data Formatting in sql server reporting services

SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2 « Journey to SQL Authority with Pinal Dave

Setting Up a Database For Integration Tests

Innovation Showcase : Creating PHP CRUD Apps with SQL Server on-premise or in the Azure Cloud

SQL-Articles - Merge Drop Slipstream Setup – SQL Server 2008

ADO.NET team blog : POCO Proxies Part 1

Find tables with identity columns in Sybase ASE

List Server Reserved Words in Sybase ASE

SSIS 2008 Flat File Source Issue

Using NHibernate order-by attribute to sort names history

How to get Sql server 2008 intellisense working for new schema changes

Adding article to existing publication without generating a full snapshot

SQL-Articles - Monitoring Replication using Scripts(Version 1.0)

Open ID Login

Standard Login

Forgot Password?

Sign up