Home SQL Server

SQL Server Engine

11 Conversations

Latest Activity

Custom List Message Item

We just featured a career profile of MVP @Jaap Brasser who focuses on Powershell, Active Directory, SQL Server, Windows Server and many other technologies.  If you're interested on his take on what a successful career in the cloud looks like, read the pos

... Read More
24 Views
0 Reply

Think you can provide some fantastic content this month, or be the most active community member?

 

We have some extra incentive for you in our March Member Madness contest, where you can win one of 15 pairs of Bose Noise Cancelling Headphones! The winners

... Read More
26 Views
0 Reply

I wonder if anyone has dabbled with this concept, or if it is economically viable to my customer, which is a "little big shop" that would like to spend $-- for SQL HA and/or DR (probably the latter is the only realistic cost-effective approach across data

... Read More
44 Views
1 Reply

Good day,

 

As you can see in the book online (under the title "THIS TOPIC APPLIES TO") Always On Availability Groups does not supported in Azure SQL Databaseno or Azure SQ

... Read More

I am using Service Broker (SQL Server 2012 SP3) with activation.

 

In the procedure used for SB Activation, a second stored procedure is called that attempts to retrieve data from a Linked Server.

 

At a high-level, this is the flow:

ServerA sends SB Message t

... Read More
35 Views
0 Reply

I have a newly installed Windows 2012R2 cluster in a restricted AD "lab" domain.

There's lots of memory and disk so I have created 3 instances in different versions to support application groups migrating/upgrading.

It all seems to work, I can connect to my

... Read More
28 Views
0 Reply

Recently, I spoke at the SQL Saturday in Atlanta on SQL Server Certifications. I posted my powerpoint presentation on my website here.  But I thought I would give a quick overview.

 

First you would need to start with one of the four MCSA cerfitications. Yo

... Read More
282 Views
0 Reply

In one of our recent project, we have used stored procedure to sort items in an ASP.NET Web Forms Grid View. Here is how we have achieved this:

 

https://www.linkedin.com/pulse/using-sql-stored-procedure-sort-items-database-table-kiril-iliev

Read More
57 Views
0 Reply

Critical Update for SQL Server 2016 MSVCRT Prerequisites KB3164398 – error 0x80070643? anyone have any ideas how this works with windows 10?

 

I have this problem since June!

888 Views
9 Replies
Good day, firstly, Josep... it make no sense to have an issue several month and ask about it only now. I highly recommend you not to skip issues. It might lead to some bi... Read More

Today I solved this. I tried to uninstall all SQL Server 2016 components, VC++ 2013 runtime, etc.. But the result was the same, the KB didn't install.

Finally, I installed

... Read More

Oh boy! Same here. I got this error for the longest and still having trying to load.

I even reported on a feedback to insider. But, no answer.

 

I did installed the missing

... Read More

I wonder about the release date for the new SQL 2016 server certification, specifically about MCSA: SQL 2016 Database Administration certification, as for now the exams are on development or beta releases.

125 Views
1 Reply

The first 3 exams are still in BETA, with the next 3 probably entering Beta next month. So I my thought would be late November or December the MCSA certs will be live.

Read More
Best Response

The Microsoft Tech Community is the official online community for Microsoft Ignite!  Join in conversations about sessions you're excited to attend by clicking here: https://techcommunity.microsoft.com/t5/forums/filteredbylabelpage/board-id/MicrosoftIgniteContent/label-name/sql%20server

... Read More
74 Views
0 Reply
Is there a sample Microsoft web application/site for playing with and demoing Always encrypted? I've looked in the usual places. I can build my own, but would like to be internet lazy :catvery-happy: and see one that someone better at this has alread... Read More
181 Views
9 Replies

Good day Karen,

 

You can download my presentation about : New Security Features in SQL Server 2016 - Presentation & Demo

 

There you can see samples for always encrypted, an

... Read More