Click here to Skip to main content
15,868,005 members
Everything / Database Development / SQL Server

SQL Server

SQL-Server

Great Reads

by Wonde Tadesse
This tip/trick helps to set a default value for blob data type such as Image, VarBinary.
by Jovan Popovic(MSFT)
Mapping properties in EF model to database columns that contain JSON
by Steve Krile
Fully AJAX-enabled user control used to select names from a database in a drop-down format.
by Mubin M. Shaikh
Create time dimension with 24 hour plus values and time buckets in your data warehouse

Latest Articles

by yuvalsol
POCO generating application for SQL Server
by scastelli
SQL resolves special character challenges, streamlining NULL parameter handling
by Federico Di Marco
spSearchTables: a helper T-SQL stored procedure for digging into (large) databases
by Federico Di Marco
Query Excel or CSV files with T-SQL without importing them in a table first

All Articles

Sort by Score

SQL Server 

15 Jan 2013 by Wonde Tadesse
This tip/trick helps to set a default value for blob data type such as Image, VarBinary.
18 Jan 2017 by Jovan Popovic(MSFT)
Mapping properties in EF model to database columns that contain JSON
24 Aug 2009 by Steve Krile
Fully AJAX-enabled user control used to select names from a database in a drop-down format.
5 Sep 2013 by Mubin M. Shaikh
Create time dimension with 24 hour plus values and time buckets in your data warehouse
22 Oct 2017 by thangchung
Learn to organize clean architecture to modular patterns
27 Nov 2009 by Max Paulousky
This article presents the techniques and caveats of building Silverlight applications that can be notified about database state changes via polling duplex. WSHttp binding and CLR triggers are used to implement the solution as well.
19 Nov 2022 by KristianEkman
An online Angular, .NET 7 Web API, SQL Server on Azure backgammon game
3 Sep 2008 by Ahmed Negm
This article introduces how to create and manage .NET enterprise applications using your favorite technology (Data Access Application Block, LINQ, NHibernate, ASMX, and WCF) with the Model Driven Development approach by Sculpture.
16 May 2013 by dale.newman
5 Nov 2002 by Alexey
The alxBase classes for work with dbf files.
14 Aug 2013 by Harmen Brouwer
How to create and deploy a SSRS rendering extension, explained by a functional Zip Rendering extension for SSRS 2005, 2008 (R2) and 2012.
6 Sep 2007 by aleksisa
Build a process to import Leads records from Excel into MS CRM via email.
9 Oct 2018 by Akhil Mittal
Entity framework core, code first migrations and data annotations in EF Core
10 Jan 2019 by Andi Kleinbichler
Illustrates the implementation of a .NET Core app, running in a Linux container, connecting to a SQL Server database with integrated security.
19 Apr 2012 by Deepak_Sharma_
This article will show how to create an auto-suggest TextBox that will suggest data from a SQL Server database column.
1 May 2018 by Shashangka Shekhar
In this post, we will get an overview and generate a basic level code using our database table column that will help in development.
25 Oct 2008 by Abhijit Jana
Overview of Log Shipping in SQL Server 2005
11 Oct 2011 by Enrique Albert
Baseline WCF Distribution Layer - Decoupling of WCF Services and ViewModels.
13 Mar 2021 by Sergii Syrovatchenko
How to omit many restrictions on SQL Server Express Edition
17 Aug 2009 by vic_ch2000
A nullable datetime column in .NET DataGrid with DateTimePicker.
5 Nov 2018 by Jovan Popovic(MSFT)
Create powerful REST API with just few lines of C# code using MsSql.RestApi package
23 Apr 2012 by Kuthuparakkal
17 Apr 2012 by Nadege Rouelle
Shows how to configure Entity Framework Code First with Data Annotations and Code Fluent.
27 Jun 2012 by freedeveloper
A small control to control paging in Windows Presentation Foundation.
7 Sep 2012 by Shivprasad koirala
This article will discuss about SQL Server governer.
22 Feb 2013 by Scott Burkow
An exercise in algorithm analysis and design.
21 Oct 2013 by Member 7874525
This how you can monitor your database changes
2 Aug 2013 by rusanu
This article will help you write better database code and will help you get started when you have to investigate performance problems.
17 Jul 2017 by Vadim Loboda
Combine Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order
15 Sep 2008 by Oleg Vorkunov
Set of SQL CLR Stored Procedures to execute T-SQL asynchronously without using a Service Broker.
31 Mar 2006 by Dan Radu
The DACBuilder application provides auto-generation features from multiple database systems in multiple programming languages.
21 Dec 2007 by Bruno Sonnino
This article will show how to use data binding and styles to show data coming from a Microsoft SQL database using the new object-relational model introduced in Visual Studio 2008, LINQ to SQL, allowing grouping, sorting and filtering of data with almost no code.
7 Sep 2009 by Tamer Oz
PocketPcAgent is an application that can be installed on Windows Mobile devices that are running Windows Mobile 5.0 or higher. The application listens to events such as SMS Received, Call Missed, E-Mail Received, Battery Strength Changed, and much more on the Pocket PC.
28 May 2010 by DecodedSolutions.co.uk
This is a simple article describing how to create an add an outlook appointment to your MS Outlook Calender.
27 Jan 2016 by DataBytzAI
How to refresh intellisense after adding new objects in Microsoft SQL Management Studio
25 Nov 2016 by kannankeril
This article is an attempt at splitting out the controller layer to reduce its complexity and improve quality and maintainability of the resulting code.
18 Dec 2016 by Afzaal Ahmad Zeeshan
Overview of SQL Server on Linux
11 Jul 2023 by Igor Krupitsky
This application lets you copy tables from folder with CSV files to SQL Server
17 Jun 2009 by Sacha Barber
SQL Server CLR functions
16 Mar 2012 by Anurag Gandhi
A Query to copy an individual table data between databases
3 Feb 2013 by S. M. Ahasan Habib
Database script execution with testing
8 Mar 2013 by Michael Haephrati
Generally speaking you need to use separate threads for the loading. I don't know what your application does during these long seconds, but whatever is done, can be done in the background. During that time you can display a Splash screen (static or animated one), so the end user will not feel...
12 May 2017 by DaveDavidson
In this article, I show LINQ to Entities syntax that will produce queries with CROSS APPLY and LEFT OUTER JOIN clauses.
27 Feb 2018 by #realJSOP
Create and run jobs kinda like SQL Server Enterprise - Users Guide
4 Nov 2016 by Wendelius
Few CLR procedure concepts to write into a file from SQL Server database
14 Mar 2000 by Tom Archer
A class to dynamically read data from any ODBC data source
9 Oct 2009 by Ferreri Gabriele (Megasoft78)
Automatic script SQL Server 2005 objects and commit under Subversion
8 Jul 2010 by Md. Marufuzzaman
How easy to read a file without using of the seven extended stored procedures.
25 Oct 2012 by Enrique Albert
WPF Validation using the IDataErrorInfo interface combined with Validation attributes
24 Jun 2013 by Enrique Albert
Azure WebSite and W8 Store App using SQL-CE, Azure SQL, Mobile Services, SignalR, EF, WebAPI and integration to Bing Maps
16 Jan 2014 by Tom Glick Philadelphia, US
POC to demonstrate passing of collections of complex objects to ASP.NET Web API Controllers.
26 Jul 2017 by Ed Wiebe
Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?
10 Apr 2018 by Gaston Verelst
Why you would use Common Table Expressions
13 Sep 2012 by Wendelius
This is an alternative for "SQL Server: Query to find upcoming birthdays for the current week"
12 Mar 2003 by Alexander Wiseman
A class to wrap the use of CDatabase and CRecordset into one object to communicate with databases
9 Mar 2005 by Sven Cipido
How to add a "select all" option to your parameter lists in SQL Reporting.
27 Jul 2009 by Paul Rony
Programmer's Guide to Starting a Software Company and Building an Enterprise Application
2 Aug 2009 by Abhishek Sur
Gives an introduction of how to create SQL CLR managed objects in SQL server.
14 Aug 2010 by Roger Wright
A simple example of creating a new database on a SQl Server instance
19 Feb 2015 by DrABELL
Technique to extend capability of standard SQL by adding the Aggregate Product Function
22 Feb 2011 by Nish Nishant
First of all I am a little skeptical that a text file (or any flat file) will have one billion records. But assuming that that's just a vague word used to mean a really large file, then you should not try and read the entire data and then write it to the database. Read it in chunks (say 3000...
27 Apr 2011 by Niladri_Biswas
This article will discuss about Copy Column, Derived Column, Character Map and Conditional Split Transformation in SSIS with a palindrome example.
11 May 2011 by Kim Togo
Check out http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring(v=VS.100).aspx[^]"Integrated Security" or "Trusted_Connection"When false, User ID and Password are specified in the connection. When true, the current Windows account credentials are...
21 Feb 2012 by Daniel Miller
This article describes the steps to re-configure SQL Server so that queries return accent-insensitive results. It includes source code (using Microsoft SQL Server 2008 R2 Shared Management Objects) to automate some of the steps in this procedure.
16 Mar 2013 by Michael Haephrati
There are several mistakes you are doing.TimeSpan is used to calculate the difference between two dates / times. You SQL query returns a single value - Test1Time.This is probably either a string or a single date/time. So you don't need to use TimeSpan, and you normally won't store a Time...
26 May 2013 by Tharaka MTR
This post will show you how to fix orphaned SQL users.
3 Nov 2013 by S. M. Ahasan Habib
I will explain here how to use table variable and over come cursor limitation
4 Nov 2015 by Fred Song (Melbourne)
Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.
4 May 2004 by Daniel Aioanei, Adi Malinaru, Andrei Postolache
An article on how to persist permutations of items in relational databases.
19 Dec 2007 by Bryan Sachdeva
This article describes how to create a wrapper class for the native Phone API, and then uses it to retrieve and store the call history.
30 May 2011 by Wonde Tadesse
Working with Max(id) + 1 is not an ideal solution. You should work by setting the column as Identity. Here is how you can do this IDENTITY (Property) (Transact-SQL)[^][EDIT]You can return the Identity value in three different ways.1. IDENT_CURRENT[^] T-SQL2. @@IDENTITY[^] T-SQL3....
11 May 2012 by P.Salini
You are getting all records for % and _ because those are wildcard characters in Like operator.To know more go through thishttp://msdn.microsoft.com/en-us/library/ms179859.aspx[^]http://www.w3resource.com/sql/wildcards-like-operator/wildcards-like-operator.php[^]
13 May 2012 by Monjurul Habib
You can use the ToString() method with a mask:ToString("MM/dd/yyyy");OR you can use .ToShortDateString();OR if you are using boundfield then try following:OR try following:Setting...
22 Jul 2013 by Paw Jershauge
Want your own movie database??? Download IMDB in 20 minutes.
6 Dec 2016 by _Asif_
This article helps in identifying database design issues like certain fields missing, nullable fields, Primary key not found issues in production environment using SQL Server schema views.
13 Oct 2016 by Wendelius
A little tip on how to format repeating values in SQL output using LAG function
23 Mar 2019 by Minh Tuan Do
A considerable method to speed up query running time
4 Nov 2021 by #realJSOP
A tool to generate model and viewmodel classes directly from your selected database
19 Feb 2019 by DiponRoy
How to do string split and join in SQL Server
13 Feb 2020 by Jeremy Likness
Tutorial for file processing and importing to SQL leveraging serverless Azure Functions
28 Jul 2000 by Len Holgate
The ATL OLE DB Provider templates appear to rely on the fact that your data is kept in a simple array, but that's not really the case at all!
9 Jan 2010 by Niladri_Biswas
How to generate an Armstrong number between 0 and 999.
19 Feb 2010 by Md. Marufuzzaman
This is good... You can also consider this link.[^]
28 Oct 2010 by Sunasara Imdadhusen
SQL Server 2005 : Generate Script with Data from Database – Database Publishing Wizard
25 Nov 2010 by Sivaraman Dhamodharan
How do you use the Template explorer and assign parameter values.
26 Jul 2011 by OriginalGriff
For goodness sake! You need to do some basic research into voice regocnition. As I suggested to you yesterday, google can help, but you are going to have to do some work.The simple approach you are trying to use will never work. Why not? A first, simple reason:When did you start talking...
5 Sep 2011 by Wendelius
You define the datetime variable as nullable:DateTime? dt = null;
4 Nov 2011 by Mehdi Gholam
Read this description : http://msdn.microsoft.com/en-us/library/ms181091.aspx[^]SQL Profiler helps you see your performance problems and gives you advise on indexes which will boost performance.SQL Profiler is tightly integrated into the SQL Server platform so substitutions will be...
4 Nov 2011 by Uday P.Singh
Google is your friend.Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine or Analysis Services.For more information read...
29 Nov 2011 by Savalia Manoj M
You Can try it in MS-SQL Like Declare @Month BigintSet @Month =11Declare @date date;Set @date='2011-11-01'while DATEPART(Month,@date)=@MonthBegin --Select DATEPART(DAY,@date); --Select DATEPART( WEEKDAY, @DATE ) DECLARE @Name VARCHAR(20) SELECT @Name = CASE (...
20 Feb 2012 by BillyGoatGruff
SQL Profiler is not included with SQL Express, this tip will help if you need to track client activity.
23 Feb 2012 by Mahmud Hasan
How to use variable in SELECT TOP SQL command
5 Mar 2012 by Chandrakantt
You can use below code for connecting to SQL server using ODBC. #include "stdafx.h"#include #include #include #include #include using namespace std;void show_error(unsigned int handletype, const SQLHANDLE&...
8 Aug 2012 by Prasad_Kulkarni
1. Never give height or width in px..unless it is necessary.2. Never give
16 Aug 2012 by Espen Harlinn
One thing you should probably consider is to use CTEs to perform paging when the table gets bigger - have a look at Data Paging Using CTE (Common Table Expression)[^]This will allow you to browse the full table, even if you end up having a 100 million records or more.Best regardsEspen...
6 Dec 2012 by Ravi Tuvar
Concatenate rows with comma separated string in SQL.
15 Sep 2013 by TheUltimateDebugger
Database operations[^]Hope it will help..
29 Dec 2013 by Christian Graus
The query profiler won't be able to do much with this mess. You have three levels of queries. As an example:select count(id) from tbl_SurveyAssignwhere ListName=a.ListName and UserName in( select UserName from tbl_Panelist where tbl_Panelist.Subscribe='1' and tbl_Panelist.Pending='0' and...