|
|
-
|
|
You can easily import data from an Excel file to SQL Server using SQL Server Import and Export Wizard. However, when the data is simple and limited I avoid using it (too lazy to click through 6 screens… ) instead I generate INSERT statements using CONCAT...
|
|
-
|
|
You can use sys.dm_exec_requests DMV to list all requests. This view also contains a hash map of the SQL text – sql_handle, which can be passed to DMF sys.dm_exec_sql_text to get the query text:
SELECT REQUEST.session_id, REQUEST.start_time, QUERY.text
FROM sys.dm_exec_requests R......
|
|
-
|
|
What if you had to create a script stack that installs SQL Server from an image library? And customisations – such as adding the SQL Server Start up account to the Lock Pages in Memory Local Policies?
If this needs to be rolled out quickly across hundreds of servers, or just one, then there ......
|
|
-
|
|
Objectives
Build Contact Page (a page that interacts with a data-storage)
Build a Contact List Page (a page with a gird)
Do it using ASP.NET WebForms
Create Unit Tests
We will use the MVP pattern and the open-source project WebFormsMVP to accomplis...
|
|
-
|
|
Recently I was in a situation where a user was required to change the password upon first login.
But MembershipUser’s ChangePassword requires 2 arguments. Old and new password. In my case the password was hashed and I couldn’t retrieve it un...
|
|
-
|
|
Twitter is great but is missing a feature that is badly wanted (at least from me). This is the ability to filter tweets based on the language of the tweet. Although some clients support automatic recognition of the language such an implementation would ...
|
|
-
|
|
A flag Enum is an Enumeration that can hold multiple values per instance An example of such Enum is:
[Flags]
public enum enDays
{
None = 0,
Monday = 1,
Tuesday = 2,
Wednesday = 4,
Thursday = 8,
Friday = 16,
Saturday = 32,
...
|
|
-
|
|
I have received many comments and questions about how you can do what is described in this post when you site requires question and answer. (Better solution at the bottom of this post)
The solution is definitely not the best and should be used with EXTR...
|
|
-
|
|
I uploaded a package in Nuget Gallery that simplifies the interaction with linked-in. Uses a modified version of Hammock (because latest version has a bug) so be careful if you want to add it to your project. When the bug is fixed the correct dependency...
|
|
-
|
|
Below are a few lines of code written in C#. Is the code bug-free? What will this print in the console? Can you do it without VS?
static void AVeryCoolMethod(){ var numbers = new[] { 1, 2, 3, 4, 5, 6 }; var ngt5 = numbers.Where(n => n > 5); var...
|
|