Explore SQL Server on Experts Exchange

Expert Solutions for Your Tech Problems

SQL ServerMicrosoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Se...

Read more
  • 171K Content
  • 16K Contributors

Expert Spotlight
Daniel Pineault (MS MVP, EE MVE)
President / Owner CARDA Consultants Inc.

Making your data sing and fixer of broken things.

Troubleshooting Solution

Powershell help for creating accounts

byAckles
284
Hello Experts,
I need help with the below :

#Requires -Module ActiveDirectory # Utility …
Article

SQL Server Calendar Table

byJim Horn
29
A demonstration of SQL Server T-SQL script that will build a calendar table, and demonstrate ways to easily query it to perform what would otherwise be complex date expressions.
Video
Executing a SQL Server Stored Procedure from Within Access 5m

Executing a SQL Server Stored Procedure from Within Access

byTechMommy
6
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft …
Tutorials
7h 55m

Microsoft SQL Server and Database Concepts

byKumar D
Beginner
SQL, or Structured Query Language, is used to communicate with a database, and is the standard …
Post

I'm glad to see Liquidweb is a new topic here. They have …

byScott Fell
I'm glad to see Liquidweb is a new topic here. They have been my web host of choice since about 2008…
Post

The Course of the Month for May: Comp TIA A+!  Prepare for …

byExperts Exchange
The Course of the Month for May: Comp TIA A+!
Prepare for the 220-901 & 220-902 exams in the month…
Troubleshooting Solution

Adding different values from a table to find a specific sum value

byCluskitt
251
There are times when I need to find a certain value out of a number of records. For example, assume …
Article

Hosting Microsoft Access Databases Online with SQL Server for Remote Access

byRichard Rost (Microsoft MVP)
2
Accessing and managing Microsoft Access databases remotely becomes practical and secure by hosting data on SQL Server, allowing distributed teams to work from anywhere while maintaining control, scalability, and improved security over traditional Access back ends.
Advice Solution

Suggestions for Remote Access to Inhouse Access apps using a tablet in the field

byEileen Murphy
24

I have a prospective client in need of an app – they do not want to go with any number of

…
Post

Is it just me or is NoSQL Overapplied? It seems like in an …

byJames Bilous
1
Is it just me or is NoSQL Overapplied? It seems like in an effort to be as trendy as possible people…
Troubleshooting Solution

SQL Server 2016 enterprise edition

bySandeep rathore
42

Dear Experts:

I need help on below disk specs which looks high and how to go for resolution:

About sql

…
Article

Dynamic Pivot Procedure for SQL Server

byMark Wills
15
by Mark Wills

PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type …
Troubleshooting Solution

Error converting Access query to SQL Server view.

bybfuchs
28

Hi Experts,

I am trying to use the following site to convert my Access SQL to SQL Server syntax.

 

And

…
Article

Troubleshooting ODBC Insert Errors with Access Linked to SQL Server

byRichard Rost (Microsoft MVP)
Unpacking the latest ODBC insert failures in Access linked to SQL Server, this piece explores how subtle shifts in data type handling, Office build updates, and long text field mapping force developers to adjust their hybrid workflows - revealing hidden frictions, crucial data prep habits, and why s
Post

So excited for SQL Server 2017. …

byKevin Cross
So excited for SQL Server 2017.
…
Troubleshooting Solution

Suspended SQL Append query

bybfuchs
17

Hi Experts,

I am trying to execute the following Append query from MS Access but for some reason

…
Troubleshooting Solution

Create a SQL Database

byWarEagleAU
141
Hi all, I am sorry for this but I have been out of town visiting a deathly ill family member and am …
Post

Who else will be attending Microsoft Ignite next week? I'd …

byShelby Walter
Who else will be attending Microsoft Ignite next week? I'd love to meet you at the show. Drop me a …
Article

Managing the Transaction Log for the Accidental DBA

byMark Wills
8
by Mark Wills

Attending one of Rob Farley's seminars the other day, I heard the phrase "The …
Article

Connect to your SQL Server

byGuy Hengel [angelIII / a3]
6
If you are already familiar with all the terms, you can…

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more