Rick Strahl's Weblog
Wind, waves, code and everything in between...
.NET • C# • Markdown • WPF • All Things Web
Contact
•
Articles
•
Products
•
Support
•
Advertise
Sponsored by:
Markdown Monster
- The Markdown Editor for Windows
advertise here
WebLog Posts in Category Sql Server
Archives
September, 2024 (1)
August, 2024 (1)
July, 2024 (4)
June, 2024 (1)
May, 2024 (2)
April, 2024 (1)
March, 2024 (2)
February, 2024 (1)
January, 2024 (2)
December, 2023 (1)
November, 2023 (2)
October, 2023 (2)
September, 2023 (2)
Categories
ASP.NET (325)
.NET (181)
Windows (77)
JavaScript (72)
jQuery (61)
Visual Studio (54)
IIS (48)
Csharp (47)
WPF (47)
HTML (46)
AJAX (45)
ASP.NET (33)
Localization (32)
LINQ (30)
WCF (28)
MVC (26)
Personal (25)
Security (23)
HTML5 (23)
FoxPro (22)
CSS (21)
C# (20)
Angular (20)
Web Services (19)
Web Api (16)
COM (16)
ADO.NET (15)
Vista (11)
XML (11)
WebView (10)
Sql Server (10)
HTTP (10)
IIS7 (10)
Markdown (9)
Microsoft AJAX (8)
IIS7 (7)
Web Connection (7)
West Wind Ajax Toolkit (7)
NuGet (6)
Markdown Monster (6)
Entity Framework (6)
Html Help Builder (5)
Live Writer (5)
Internet Explorer (5)
C++ (5)
ASPNET5 (5)
Mobile (5)
SignalR (5)
Software Development (5)
Web (5)
OWIN (5)
WinForms (5)
Westwind.Globalization (4)
Source Control (4)
Silverlight (4)
Cordova (4)
Conferences (3)
DataBinding (3)
ASP.NET Core (3)
Help Builder (3)
ISV (3)
LetsEncrypt (3)
Networking (3)
Office (3)
Opinion (3)
Razor (3)
Web Browser Control (3)
WebLog (3)
Web Development (2)
Visual Studio Code (2)
Tools (2)
Speaking (2)
RegEx (2)
RSS (2)
Linux (2)
Installation (2)
Bugs (2)
Help (2)
Dotnet (2)
.NET Standard (2)
Addins (2)
Deployment (2)
Authentication (2)
ASP.NET vNext (2)
ADO.NET (1)
Chocolatey (1)
Blazor (1)
Blogging (1)
Desktop (1)
Control Development (1)
Credit Card Processing (1)
Cross-Platform (1)
.NET ASP.NET Windows (1)
Security (1)
Visual Studio (1)
ASP.NET IIS (1)
ASP.NET Markdown (1)
AI (1)
Angular JavaScript (1)
Dynamic Types (1)
Email (1)
CSharp Dotnet (1)
Git (1)
Graphics (1)
Hardware (1)
FireFox (1)
Flexbox (1)
IOS (1)
JSON (1)
Migration (1)
rxJs (1)
SEO (1)
RazorPages (1)
Musings (1)
Travel (1)
Typescript (1)
Testing (1)
Threading (1)
VS Code (1)
Web Deployment Projects (1)
Web Design (1)
Web Assembly (1)
WebSockets (1)
WebSurge (1)
WebBrowser (1)
WebDeploy (1)
WFH (1)
Windows-Terminal (1)
Windsurfing (1)
WPF Windows (1)
WSL (1)
wwHoverPanel (1)
Connection Failures with Microsoft.Data.SqlClient 4 and later
17 comments
December 07, 2021 - Maui, Hawaii
After a recent update to `Microsoft.Data.SqlClient` version `4.0.0.0` I ended up not being able to connect to any of my SQL Server databases. Turns out Microsoft has made some default settings changes in the updated provider and these settings are likely going to break connections.
Slow Connections with Sql Server
6 comments
October 26, 2018 - Maui, Hawaii
Ran into a problem with extremely slow SQL Server connections when connecting to the server. Connections would take 2 seconds or more even on repeat connections. It turns out the problem is related to missing TCP/IP protocol support which is disabled by default.
Resetting Entity Framework Migrations to a Clean Slate
15 comments
January 13, 2016 - Maui, HI
I've had a number of problems with Entity Framework Migrations getting out of whack to the point were I can't get the database and the migrations into sync to accept new changes. I've found that rather than spending hours fixing out of whack migrations it's sometimes much easier to simply wipe the slate clean and create a new initial migration. This post describes the steps on how to remove existing migrations and create a new initial migration from the current schema.
Basic Spatial Data with SQL Server and Entity Framework 5.0
11 comments
June 21, 2012 - Hood River, Oregon
Spatial data has been available for a while in SQL Server, but if you wanted to use it with Entiry Framework you had to jump through some hoops. In this post I show how basic SQL Spatial data works and then how you can utilize the new features in EF 5.0 to directly access spatial data using your CodeFirst models.
Sql 2008 Management Tools: Can't save changes that require Recreation of Database
81 comments
August 16, 2008 - Hood River, OR
Ah here's a silly new default in SQL Server's Management Tools: When you design a table in a database and then try to make a change to a table structure that requires the table to be recreated, the management tools will not allow you to save the changes. Instead you'll be greeted by this friendly dialog: Notice that there's no option to save the changes - it's a hard rule that is applied and you...
An easier Table Design View in Sql Server Management Studio
14 comments
January 25, 2008 - Maui, Hawaii
One of the things that bugs me no end in Sql Server Management Studio is that the table designer's UI is a pain to use. Entering column properties is an excercise in mousercise. It turns out there's an easier way to do this with custom views in the DataBase Diagram Designer.
First Impressions on LINQ to SQL
14 comments
September 11, 2007 - Hood River, Oregon
I've been experimenting with LINQ to SQL for the last few weeks and there's a lot to like as well as a few things to think about. In this editorial I'll describe some of the things that worked well and some of the issues I struggled with and how I worked around them.
Generate Scripts in Sql Management Studio
8 comments
March 08, 2007 - Maui, Hawaii
Sql 2005 Management studio's Generate Scripts iritates the hell out of me with its Wizard based approach and no way to step through the choices after generation again.
SQL Server 2005 Windows Security has gone out to lunch...
1 comment
January 15, 2007 - Maui, Hawaii
While experimenting with UAC on Vista, somehow, somewhere my SQL Server Windows Authentication has somehow disconnected itself from my SQL Server installation. SQL Server no longer sees the Administrators group AT ALL and so several database connections that have been working off integrated security now suddenly fail.
Sql Server Bonk today
1 comment
November 22, 2006 - Maui, Hawaii
This morning my site went down due to SQL Server bonking out. Sql went down completely and wouldn’t restart until I rebooted.