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
Senior DBA (Microsoft MVP)

Senior DBA, SQL Server, specialising in tuning / performance.

Research Solution

any related flow diagram about column encryption ?

85

hi,


I found out that there are 2 x column encryption in SQL server 2019:


1) column encryption

2) Always

Article

SQL Server Calendar Table

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
Tutorials
Post

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

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

How to recommend the correct clustered index --- for all tables.

bydbaSQL
81

This is a new one for me...  SQL Server v2016 sp2.  A customer says they have a script that needs to

Post

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

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

How do I access the SQL server to configure data source in ASP.net?

byrckrch
76

I have installed sql server and sql management studio on my system. However, when I try to use ASP

Troubleshooting Solution

Powershell help for creating accounts

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

#Requires -Module ActiveDirectory # Utility …
Troubleshooting Solution

Website running from IIS with ASP Classic and SQL Server runs slow, other times fast.

46

Hello all.
Specs: 

Dell PowerEdge R710 = CPU = 2 x E5530 @ 2.40GHz (8 CPUs)
Memory = 119.99 GB
VMWare 

Troubleshooting Solution

Closing a SQL Server file with VB6

18

How can I close a sql server file (*.mdb and *.ldf) so I can send it to the recycle bin and then

Troubleshooting Solution

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

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

SharePoint 2013 Local Server - Accessing Old List Items to Remove

byJake S
28

I have a space issue with SQL Express on a local SharePoint 2013 server.  I wanted to get rid of

Troubleshooting Solution

Write conflict in Access using SQL Client 11 ODBC Driver

15

I have a Microsoft Access application that links to an SQL server database.  If the ODBC driver is

Post

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

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

Dynamic Pivot Procedure for SQL Server

15
by Mark Wills

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

SQL 2016 security feature called Always Encrypted- column-level encryption,

64

hi,


  We have a concern on current encryption on SQL 2016 standard so that Hacker can't hack our

Troubleshooting Solution

SQL Server 2019 Standard Edition - Server/CAL    Or    SQL Server 2019 Standard Edition - Per Core

15

Hi

We have Windows 2019 server and SQL server 2012 is running on this server. I would like to do an

Advice Solution

Will exceeding the 10 GB size of SQL Server Express' database possibly cause significant performance issues?

13

I have a question about a specific performance issue with SQL Server Express when the 10 GB limit is

Troubleshooting Solution

Upgrade path - Windows 2012R2 to Windows 2016

25

Hi 


We use VMware Vsphere version 7.0.3  and Veeam backup.


I have Windows 2012 R2 and SQL 2012

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more