DotNetShoutout

SQL

16
Shouts

Shout it

What is a Technology Evangelist?

published 844 days, 9 hours, 32 minutes ago posted by

pinaldave 848 days, 8 hours, 31 minutes ago

Technology evangelists are individuals who, professionally or in their spare time, spread the news about the latest new products. Sounds like a salesperson, right? No they are absolutely different. Salespeople also keep up to date with a large number of people, and like to convince others to buy their product – and some will go to any lengths to sell! An evangelist, on the other hand, is brutally honest about the product, even if sometimes it means not making a sale. An evangelist is out there to tel... (more)

category: Architecture | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

2
Shouts

Shout it

20 important SQL Server interview questions on Service Broker - Part 1

posted by

questpond 857 days, 12 hours, 27 minutes ago

This section is Part 1 and it will cover the most asked SQL Server interview questions by the interviewer so have a look on the following and do revise it when ever you go for the SQL Server interview (more)

category: Data | clicked: 3 | comment | | source: www.questpond.com

| flag as spam

tags: SQL, service broker, Interview Question

9
Shouts

Shout it

SQL SERVER – Shrinking Database is Bad – Increases Fragmentation – Reduces Performance « Journey to SQL Authority with Pinal Dave

published 857 days, 8 hours, 5 minutes ago posted by

pinaldave 857 days, 19 hours, 3 minutes ago

Earlier, I had written two articles related to Shrinking Database. I wrote about why Shrinking Database is not good.SQL SERVER – SHRINKDATABASE For Every Database in the SQL ServerSQL SERVER – What the Business Says Is Not What the Business Wants I received many comments on Why Database Shrinking is bad. Today we will go over a very interesting example that I have created for the same. Here are the quick steps of the example.Create a test databaseCreate two tables and populate with dataCheck the si... (more)

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

tags: SQL, SQLServer, pinaldave, SQLAuthority

11
Shouts

Shout it

Creating Missing Index and Improve SQL Server Performance

published 863 days, 9 hours, 2 minutes ago posted by

pinaldave 864 days, 32 minutes ago

A Quick Script which you can right away run and improve SQL Server Performance. (more)

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

tags: SQL, SQLServer, pinaldave, SQLAuthority

3
Shouts

Shout it

VS 2010 SP1 and SQL CE - ScottGu's Blog

published 862 days, 14 hours, 35 minutes ago posted by

http://kazimanzurrashid.myopenid.com/ 864 days, 19 hours, 12 minutes ago

Last month we released the Beta of VS 2010 Service Pack 1 (SP1). You can learn more about the VS 2010 SP1 Beta from Jason Zander’s twoblog posts about it, and from Scott Hanselman’s blog post that covers some of the new capabilities enabled with it. You can download and install the VS 2010 SP1 Beta here. Last week I blogged about the new Visual Studio support for IIS Express that we are adding with VS 2010 SP1. In today’s post I’m going to talk about the new VS 2010 SP1 tooling support for SQL CE, an... (more)

category: Architecture | clicked: 2 | comment | | source: weblogs.asp.net

tags: SQLCE, SQL, VS2010, ASP.NET

2
Shouts

Shout it

21 important SQL Server interview questions on .NET integration - Part 1

posted by

questpond 865 days, 12 hours, 57 minutes ago

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

| flag as spam

tags: SQL, Interview Question

4
Shouts

Shout it

SQL Server: Join tables from 2 databases, collation issue

published 865 days, 8 hours, 36 minutes ago posted by

jphellemons 865 days, 16 hours, 44 minutes ago

Just a small blog article about collation issue you might hit when you join two tables from different databases and how to solve it (more)

category: Data | clicked: 1 | comment | | source: www.jphellemons.nl

tags: SQL

2
Shouts

Shout it

How to Create Full Database Backup on MS SQL Server for a Database using Backup Database command and SqlCmd Utility

posted by

eralper 869 days, 15 hours, 55 minutes ago

Below is the t-sql statement which takes a full database backup of a given SQL Server database with database name as a parameter to a given file folder as parameter on the same server or computer. In order to complete the creating a full database sql backup task, we will use the T-SQL BACKUP DATABASE statement. (more)

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

| flag as spam

tags: SQL Server, SQL, T-SQL, backup, Database

9
Shouts

Shout it

SQL SERVER – Copy Statistics from One Server to Another Server « Journey to SQL Authority with Pinal Dave

published 869 days, 1 hour, 16 minutes ago posted by

pinaldave 870 days, 23 hours, 29 minutes ago

A very efficient way of copying database statistics from one server to another server without moving data. (more)

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

tags: SQL, SQLServer, pinaldave, SQLAuthority

2
Shouts

Shout it

SSAS: Using fake dimension and scopes for dynamic ranges

published 896 days, 10 hours, 12 minutes ago posted by

gpeipman 897 days, 2 hours, 30 minutes ago

In one of my BI projects I needed to find count of objects in income range. Usual solution with range dimension was useless because range where object belongs changes in time. These ranges depend on calculation that is done over incomes measure so I had really no option to use some classic solution. Thanks to SSAS forums I got my problem solved and here is the solution. (more)

category: How To | clicked: 2 | comment | | source: weblogs.asp.net

tags: SSAS, SQL

2
Shouts

Shout it

SQL Profiler - DeadLock Graph

published 896 days, 10 hours, 12 minutes ago posted by

dotnetfunda 898 days, 13 hours, 50 minutes ago

One of the nightmares of a developer is the deadlock. The main source of a deadlock is the backend code, SQL Server scripts. In this article, we will discuss about how to use the SQL Profiler to capture the deadlocks in SQL Statements. (more)

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

tags: SQL

2
Shouts

Shout it

Case Sensitive SQL Split Function

published 902 days, 18 hours, 19 minutes ago posted by

eralper 903 days, 15 hours, 24 minutes ago

In this T-SQL tutorial, SQL developers can find a sample sql case sensitive split string function. This sample SQL split string function identifies upper case letters and behaves as the start of a new word. For example, let the input argument to the case sensitive sql split function be "ThisIsASqlServerCaseSensitiveSplitStringFunction". We expect the output of the sql split function as identifying the words just like in the sentence : "This Is A Sql Server Case Sensitive Split String Function" (more)

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

tags: SQL Server, Split, SQL, T-SQL

6
Shouts

Shout it

SQL Azure + OData + WP7 = AWESOME - Rudi Grobler in the Cloud

published 905 days, 13 hours, 17 minutes ago posted by

http://rudigrobler.myopenid.com/ 905 days, 18 hours, 46 minutes ago

A article on how to use SQL Azure with WP7 using OData (more)

category: Metro | clicked: 2 | comment | | source: www.rudigrobler.net

tags: SQL

4
Shouts

Shout it

Continuous Integration Tip #3 – Version your Databases as part of your automated build

published 905 days, 13 hours, 17 minutes ago posted by

http://www.google.com/profiles/dougrathbone 905 days, 20 hours, 2 minutes ago

Having a good Continuous Integration setup is the gift that keeps on giving, but what about your database? For most web applications these days, your database is a large part of your application – so why is versioning it such an uncommon thing? Because it’s time consuming and complicated – two requirements that Continuous Integration love conquering with a one-two punch. (more)

category: Agile | clicked: 2 | comment | | source: www.diaryofaninja.com

tags: SQL, Database, Continuous Integration

4
Shouts

Shout it

Defeating Red Gate’s SQL Source Control insensitivity

published 905 days, 13 hours, 17 minutes ago posted by

http://troyhunt.myopenid.com/ 906 days, 16 hours, 37 minutes ago

I’m a big fan of Red Gate’s SQL Source Control, I really am. I raved about it earlier in the year and I still think it’s the best solution going for getting your databases under source control with Subversion. However, I’ve hit a glitch which unless I’m wrong, appears to be a bit of a design flaw; versioning changes in case. But there is a workaround... (more)

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

tags: SQL, Source Control

4
Shouts

Shout it

SQL Paging in SQL Server 2011 using SQL ORDER BY OFFSET and FETCH NEXT

published 912 days, 30 minutes ago posted by

eralper 913 days, 20 hours, 38 minutes ago

One of the major SQL Server 2011 features related with t-sql programming enhancements is the SQL paging using ORDER BY OFFSET n ROWS and FETCH NEXT n ROWS ONLY syntax. In this sql tutorial, while showing one of the new t-sql features in SQL Server 2011 Denali, I will use the sample SQL database AdventureWorks download from CodePlex (more)

category: Data | clicked: 0 | 2 comments | | source: www.kodyaz.com

tags: Paging, SQL, T-SQL, denali, SQL Server 2011

11
Shouts

Shout it

Are you Database Developer or Database Administrator?

published 918 days, 32 minutes ago posted by

pinaldave 920 days, 15 hours, 20 minutes ago

Your opinion matters! (more)

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

tags: SQL, SQLServer, pinaldave, SQLAuthority

7
Shouts

Shout it

Connecting to SQL Azure with SQL Server 2008 R2 Tools - Zach Skyles Owens

published 922 days, 14 hours, 40 minutes ago posted by

Klugger 924 days, 1 hour, 20 minutes ago

Back in October I wrote a post on how to connect to SQL Azure. With the release of the November CTP of SQL Server 2008 R2 working with SQL Azure from within SQL Server Management Studio (SSMS) got a whole lot better! You can get a free copy of SSMS here:SQL Server 2008 R2 Tools for x86SQL Server 2008 R2 Tools for x64 Because this is a CTP you may want to install these in a Virtual PC although I haven’t had any issues. Once you have this installed all of the issues I outlined in my previous post abo... (more)

category: Data | clicked: 0 | comment | | source: english.zachskylesowens.net

tags: SQL, SQL Azure, Tools, SQL Server 2008 R2

9
Shouts

Shout it

Beware of limitation of Quotename() function - Madhivanan's TSQL Blog

published 940 days, 8 hours, 25 minutes ago posted by

dhara 940 days, 20 hours, 52 minutes ago

Quotename() function is used to return a unicode string with delimiters. A delimiter can be a single quote, double quote or braces ( or [. select quotename('test','''') as single_quote, quotename('test','"'... (more)

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

tags: TSQL, SQL

2
Shouts

Shout it

SQL Trigger Example in SQL Server 2008

published 945 days, 5 hours, 32 minutes ago posted by

eralper 946 days, 16 hours, 16 minutes ago

What is SQL Server Trigger An SQL trigger can contain sql codes that are executed automatically by SQL Server engine when a certain event occurs. Since this sql tutorial is concentrated on DML (Data Manipulation Language) concepts right now, our sql code examples will be a DML sql trigger. And the following SQL Server trigger definition will be valid for DML commands. The events that trigger SQL Server triggers which are actually stored t-sql codes are sql INSERT, UPDATE and DELETE statements executed... (more)

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

tags: SqlServer 2008, SQL, T-SQL, Trigger, SQLServer, sqlserver2005

Welcome!

SQL

What is a Technology Evangelist?

20 important SQL Server interview questions on Service Broker - Part 1

SQL SERVER – Shrinking Database is Bad – Increases Fragmentation – Reduces Performance « Journey to SQL Authority with Pinal Dave

Creating Missing Index and Improve SQL Server Performance

VS 2010 SP1 and SQL CE - ScottGu's Blog

21 important SQL Server interview questions on .NET integration - Part 1

SQL Server: Join tables from 2 databases, collation issue

How to Create Full Database Backup on MS SQL Server for a Database using Backup Database command and SqlCmd Utility

SQL SERVER – Copy Statistics from One Server to Another Server « Journey to SQL Authority with Pinal Dave

SSAS: Using fake dimension and scopes for dynamic ranges

SQL Profiler - DeadLock Graph

Case Sensitive SQL Split Function

SQL Azure + OData + WP7 = AWESOME - Rudi Grobler in the Cloud

Continuous Integration Tip #3 – Version your Databases as part of your automated build

Defeating Red Gate’s SQL Source Control insensitivity

SQL Paging in SQL Server 2011 using SQL ORDER BY OFFSET and FETCH NEXT

Are you Database Developer or Database Administrator?

Connecting to SQL Azure with SQL Server 2008 R2 Tools - Zach Skyles Owens

Beware of limitation of Quotename() function - Madhivanan's TSQL Blog

SQL Trigger Example in SQL Server 2008

Open ID Login

Standard Login

Forgot Password?

Sign up