DotNetShoutout

SQL Server

5
Shouts

Shout it

Working with SQL Server Logins | Just Like a Magic

posted by

http://elsheimy.myopenid.com/ 1057 days, 18 hours ago

This lesson discusses all the details of SQL Server logins. It begins by discussing how to create SQL Server logins. After that, it focuses on how to change the properties of existing login. Next, it discusses how to delete an existing login. Moreover, we will focus on how to enumerate a list of existing logins and roles. Lastly, we will talk a look on how to manage login permissions in SQL Server. In addition, we will link between SQL Server and .NET Framework and we will teach you many techniques other... (more)

category: Data | clicked: 0 | comment | | source: justlikeamagic.com

| flag as spam

tags: SQL Server, .NET, Security, T-SQL

3
Shouts

Shout it

Exclusive access could not be obtained because the database is in use

posted by

dotnetfunda 1063 days, 2 hours, 35 minutes ago

You might get the error related to "Exclusive access could not be obtained because the database is in use" so, in this article we will gain over this error. (more)

category: Data | clicked: 0 | comment | | source: www.dotnetfunda.com

| flag as spam

tags: SQL Server

8
Shouts

Shout it

TSQL Challenge 34 - Search for two keywords within the maximum distance of one word between them - TSQL Challenges

published 1064 days, 21 hours, 27 minutes ago posted by

jacobsebastian 1065 days, 9 hours, 31 minutes ago

This challenge is all about searching for two keywords in a string with a maximum distance of 'one word' between them (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, Puzzle, TSQL, challenge

4
Shouts

Shout it

Introduction of the Cursors in SQL Server

published 1064 days, 21 hours, 27 minutes ago posted by

codegain 1065 days, 21 hours, 52 minutes ago

Stored procedures are stored in SQL Server databases. The simplest implication of stored procedures is to save complicated queries to the database and call them by name, so that users won’t have to enter (more)

category: Data | clicked: 0 | comment | | source: codegain.com

tags: SQL Server, cursors, SQL, Stored Procedure

4
Shouts

Shout it

Generating and exporting SSRS reports programatically using Report Viewer Control

published 1070 days, 16 minutes ago posted by

jacobsebastian 1071 days, 5 hours, 15 minutes ago

This post demonstrates how to generate SSRS reports programatically from an ASP.NET web page using Report Viewer control. (more)

category: Web Dev | clicked: 5 | comment | | source: beyondrelational.com

tags: SQL Server, Reporting, SSRS

6
Shouts

Shout it

Validating an SQL query programmatically, with gotcha | AdaTheDev

published 1079 days, 3 hours, 37 minutes ago posted by

AdaTheDev 1080 days, 5 hours, 36 minutes ago

A run through of how to validate an SQL query programmatically, but with a gotcha. (more)

category: Data | clicked: 4 | comment | | source: www.adathedev.co.uk

tags: SQL Server, SQL

9
Shouts

Shout it

New Embedded Database Support with ASP.NET - ScottGu's Blog

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

raju 1085 days, 6 hours, 46 minutes ago

Earlier this week I blogged about IIS Express, and discussed some of the work we are doing to make ASP.NET development easier from a Web Server perspective. In today’s blog post I’m going to continue the simplicity theme, and discuss some of the work we are also doing to enable developers to quickly get going with database development. In particular, I’m pleased to announce that we’ve just completed the engineering work that enables Microsoft’s free SQL Server Compact Edition (SQL CE) database to work ... (more)

category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net

tags: SQL Server, .NET, Visual Studio, IIS Express, ScottGu, ASP.NET

8
Shouts

Shout it

Native .NET Local Storage with VistaDB

posted by

http://vistadb.myopenid.com/ 1085 days, 16 hours, 25 minutes ago

Distributed applications often need local storage. The requirements for local storage are adequate performance, reliability, integration with your existing tools and ease of deployment. VistaDB scores well on all of these fronts. While compact, VistaDB doesn't skimp on database technologies you'd expect, providing referential integrity, views and stored procedures, and a transaction monitor. Granted, in the Microsoft .NET Framework, all database engines tend to look alike, but the people at Infinite Cod... (more)

category: Data | clicked: 5 | comment | | source: visualstudiomagazine.com

| flag as spam

tags: SQL Server, desktop, VistaDB, Database

7
Shouts

Shout it

Building a plug-in model to load VistaDB - Part II

published 1092 days, 2 hours, 45 minutes ago posted by

http://vistadb.myopenid.com/ 1093 days, 20 hours, 30 minutes ago

Plugins are used in data applications to support more than one provider from a single codebase. The Provider Factories in ADO.Net is one such example, but you cannot work with the provider specific features when you use these factories since they only implement generic ADO.Net functions. If you need to be able to use provider specific functions (like VistaDB’s DDA Pack routines), you have to load the provider somehow. In most cases you put that logic and bindings into a separate assembly and load it w... (more)

category: Data | clicked: 0 | comment | | source: infinitecodex.com

tags: SQL Server, Plug-In, C#, VistaDB

7
Shouts

Shout it

DeepFriedBytes - Episode 56: What is new in SQL Server 2008 R2?

published 1096 days, 59 minutes ago posted by

mithu 1096 days, 8 hours, 11 minutes ago

In this episode Keith and Woody sat down shortly after SQL Server 2008 R2 was released to MSDN to discuss this major update for SQL Server. With this release, SQL Server is moving away from being just a database and starting to be an information platform. New features like SteamInsight, improved reports and updated BI tools make this a release that is very exciting for all developer in the community. Thanks To Our Sponsor DevExpress products are built by developers for developers. W... (more)

category: Podcast | clicked: 2 | comment | | source: deepfriedbytes.com

tags: SQL Server, SQL Server 2008, MSDN, DeepFriedBytes, SQL Server 2008 R2

6
Shouts

Shout it

Just in Time Debugging CLR Procs

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

http://vistadb.myopenid.com/ 1099 days, 10 hours, 46 minutes ago

This topic comes up frequently when users are writing CLR Procs and Triggers. How do I debug the code that is being hosted by the database? There is a very easy way to do it through the System.Diagnostics.Debugger namespace to launch the just in time debugger for Visual Studio.Prompting the user for the debugger You can prompt the user to attach a debugger at runtime using the System.Diagnostics.Debugger. You would NEVER want to do this at runtime in a production environment! Only for use on your deve... (more)

category: Data | clicked: 1 | comment | | source: infinitecodex.com

tags: SQL Server, VistaDB, Debugging, Clr procedures

6
Shouts

Shout it

Building a plug-in model to load VistaDB

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

http://vistadb.myopenid.com/ 1099 days, 14 hours, 10 minutes ago

In this article I will explain how to build an application that uses VistaDB and Microsoft’s SQL Server, without being hard bound against their providers directly. Many companies desire to offer the choice from several database providers in a single product or API. In many cases if you were directly bound, but the provider not installed, you would get a dll not found exception at startup. There are two ways to handle this scenario. The most common method is to use ADO.Net Provider Factories and load... (more)

category: Data | clicked: 1 | comment | | source: infinitecodex.com

tags: SQL Server, VistaDB, Plugin

6
Shouts

Shout it

TSQL Challenge 32 - Clean up phrases by removing noise words - TSQL Challenges

published 1100 days, 2 hours, 8 minutes ago posted by

jacobsebastian 1100 days, 6 hours, 58 minutes ago

The idea of this challenge is to clean up the phrase from the words identified as noise words, but only when these words appear at the begining or the end of the string, not in the middle of the string. Your job is to read each row from the source table and remove any noise words from it. The noise words that you need to remove are stored in another table. You should remove the noice words only if they appear at the beginning or end of the sentences. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, DBA, Puzzle, TSQL, developer, challenge

8
Shouts

Shout it

T-SQL Enhancements in SQL 2008

published 1103 days, 2 hours, 23 minutes ago posted by

jacobsebastian 1105 days, 2 hours, 57 minutes ago

Seth Phelabaum explains his favorite TSQL programmability enhancements added in SQL Server 2008. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL, developer, Database, Programmability

5
Shouts

Shout it

Calculating visit length by first and last visit time in SSRS - Some Random Thoughts

published 1105 days, 2 hours, 32 minutes ago posted by

jacobsebastian 1106 days, 2 hours, 20 minutes ago

beyondrelational.comSign in | Join | Help HomeBlogsForumsBIXMLTCSQL Tools Visit the new SQL Server Tools and Utilities section and see the products that can make your database administration and development lives easier! First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login. Some Random ThoughtsHomeContactRSS for PostsRecent Blog PostsCalculat... (more)

category: Data | clicked: 0 | 1 comment | | source: beyondrelational.com

tags: SQL Server, Reporting Services, SSRS, Custom Functions

3
Shouts

Shout it

TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node - TSQL Challenges for Beginners

posted by

jacobsebastian 1107 days, 7 hours, 52 minutes ago

This challenge refers to a real-world problem I came across recently. The requirement was to identify all 'direct' or 'indirect' parents of a given child node and all its siblings. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

tags: SQL Server, Puzzle, TSQL, developer, Database, challenge

3
Shouts

Shout it

SQL Server Database Mail sp_send_dbmail Example

posted by

eralper 1107 days, 17 hours, 16 minutes ago

SQL Server Database Mail spsenddbmail Example Here is a sample t-sql code using spsenddbmail system stored procedure to send email from SQL Server. Since Database Mail feature is first introduced to administartors and developers with MS SQL Server 2005, SQL Server administrators and t-sql developers can use the below spsenddbmail example sql code on a Microsoft SQL Server 2005, MS SQL Server 2008 or SQL Server 2008 R2 instance (more)

category: Data | clicked: 6 | comment | | source: www.kodyaz.com

| flag as spam

tags: SQL Server, database mail, SQL Server 2008, sp_send_dbmail, SQL Server 2005

8
Shouts

Shout it

Understanding SQL Server Datetime column - Part II

published 1107 days, 1 hour, 41 minutes ago posted by

jacobsebastian 1108 days, 5 hours, 54 minutes ago

SQL Server MVP, Madhivanan has come up with the second installment of his DateTime tutorial where he explains the problems of using ambiguous date formats. He also demonstrates a number of TSQL datetime processing tricks. (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, DateTime, DataTypes, TSQL, Date, time

5
Shouts

Shout it

Building a Dynamic LINQ to Entities Compiler (Part 1)

posted by

http://vistadb.myopenid.com/ 1108 days, 6 hours, 59 minutes ago

In this article I will explain how to build a dynamic LINQ to Entities compiler for any database provider that supports the Ado.net Entity Framework. Due to the wide range of technologies used this article, it will be broken up into two parts as listed below. We are working on a dynamic linq query mechanism for the next major release of VistaDB. Our goal is to provide a LinqPad type of environment in Data Builder for users to write LINQ queries against the database without having to first build an EF m... (more)

category: Data | clicked: 0 | comment | | source: infinitecodex.com

| flag as spam

tags: SQL Server, Entity Framework, VistaDB, SQL, Linq

4
Shouts

Shout it

Group By Date Time without milliseconds in T-SQL

published 1108 days, 2 hours, 2 minutes ago posted by

Praveen 1109 days, 17 minutes ago

There are lot of requirements which needs some complex logic and put maximum effort to implement them. The below scenario is the one I want to explain in writing T-SQL queries. The requirement is very simple, I want to apply group by on DateTime field in database which does not includes the milliseconds part from the time. So, on the UI I need to group by and show records with seconds and but not with milliseconds. In my fi... (more)

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

tags: SQL Server, T-SQL, Group by, time

Welcome!

SQL Server

Working with SQL Server Logins | Just Like a Magic

Exclusive access could not be obtained because the database is in use

TSQL Challenge 34 - Search for two keywords within the maximum distance of one word between them - TSQL Challenges

Introduction of the Cursors in SQL Server

Generating and exporting SSRS reports programatically using Report Viewer Control

Validating an SQL query programmatically, with gotcha | AdaTheDev

New Embedded Database Support with ASP.NET - ScottGu's Blog

Native .NET Local Storage with VistaDB

Building a plug-in model to load VistaDB - Part II

DeepFriedBytes - Episode 56: What is new in SQL Server 2008 R2?

Just in Time Debugging CLR Procs

Building a plug-in model to load VistaDB

TSQL Challenge 32 - Clean up phrases by removing noise words - TSQL Challenges

T-SQL Enhancements in SQL 2008

Calculating visit length by first and last visit time in SSRS - Some Random Thoughts

TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node - TSQL Challenges for Beginners

SQL Server Database Mail sp_send_dbmail Example

Understanding SQL Server Datetime column - Part II

Building a Dynamic LINQ to Entities Compiler (Part 1)

Group By Date Time without milliseconds in T-SQL

Open ID Login

Standard Login

Forgot Password?

Sign up