Home

SQL Server Engine

15 Conversations

Latest Activity

Custom List Message Item

Atlanta-based Homer McEwen has been a database administrator for more than 20 years. But it’s what he does in his spare time that makes McEwen, aka KillaDBA, a little different. The husband and father of three writes and records songs about SQL Server, th

... Read More
958 Views
0 Reply

Hi everyone!

 

I am preparing for to take the SQL exam 70-461.  In the study guide, I find the following phrase very confusing: "Create tables (and views) without using the built in tools".  Could anyone kindly clarify what this means?  I intrepret this to

... Read More
36 Views
0 Reply

Hello.

 

Could you suggest if there are any considerations regarding disk size for database files? Are there any limitations from MS SQL?

Version that we use is SQL 2014 SP1.

What we need is handling 200+ SharePoint content databases of total size about 16TB.

... Read More
210 Views
3 Replies

Hi Alex, It depends on Storage design. If you can describe what you have in terms of Storage I can help you with the desing.

Let me know the storage model, disks number an

... Read More

Recently, I have spoken at several user groups and/or SQL Saturday events on SQL Server Certifications. I have posted my powerpoint presentation below. But I thought I would give a quick overview.

 

First you will need to start by earning one of the four ei

... Read More
2,595 Views
4 Replies

Really helpful John - thank you.

 

Quick question on the learning paths though. Have MS retired the 70-463 alternative options or are they still valid?  One of my old stude

... Read More

Capture.JPG

That's right, I said FREE!  You're invited to a free, one day technical conference for SQL Server professionals.  The user community for SQL Server is extremely passionate and have developed a contagious set of one day events around the world with the sup

... Read More
253 Views
0 Reply

Atlanta-based Homer McEwen has been a database administrator for more than 20 years. But it’s what he does in his spare time that makes McEwen, aka KillaDBA, a little different. The husband and father of three writes and records songs about SQL Server, th

... Read More
958 Views
0 Reply

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
205 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
133 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
170 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
100 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
194 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
122 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!

1,201 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.

294 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
153 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
321 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