A Fine Slice Of SQL Server
Kenneth Fisher needs a new BACPAC:
Why are we talking about it?
Well there are two reasons. First because I’m studying how to move databases from SQL Server to Azure SQL Database and back. My first blog on the subject was using the Deploy Database to Microsoft Azure SQL Database option to move a SQL Server database to Azure SQL Database.
Kenneth shows you how to do this through the UI as well as through SqlPackage.exe.
Comments closedMark Russinovich announces that Azure Service Fabric will be available on Linux:
Given its beginnings, Service Fabric supports Windows servers and .NET applications, but many enterprises today run heterogeneous workloads, including Windows and Linux servers, .Net and Java applications, and SQL and NoSQL databases. That’s why I am excited to announce today that the preview of Service Fabric for Linux will be publicly available at our Ignite conference on September 26. With today’s announcement customers can now provision Service Fabric clusters in Azure using Linux as the host operating system and deploy Java applications to Service Fabric clusters. Service Fabric on Linux will initially be available for Ubuntu, with support for RHEL coming soon.
This isn’t a huge announcement for many people, but it’s a positive sign.
Comments closedKevin Hill with an introductory-level discussion of Azure SQL Database:
Some basic terminology:
Cloud: No such thing. It is just your stuff on someone else’s machines that they maintain for you.
Virtual Machine (VM): A Virtual Server on some physical servers…yours, or someone else’s.
Azure: Fancy name for Microsoft’s cloud. As a noun or an adverb it means “blue”. Or a small butterfly.
Azure SQL database: Just a database in Azure on some storage
Azure Virtual Machine: A VM on Microsoft’s Azure servers, that you do not have to maintain the underlying physical infrastructure.
This is a nice, very high-level introduction to why Azure SQL Database exists.
Comments closedMala Mahadevan discusses how to perform a Chi Square test:
For any dataset to lend itself to the Chi Square test it has to fit the following conditions –
1 Both variables are categorical (in this case – exposure to smoking – yes/no, and health condition – sick/not sick are both categorical).
2 Researchers used a random sample to collect data.
3 Researchers had an adequate sample size.Generally the sample size should be at least 100.
4 The number of respondents in each cell should be at least 5.
This is an easy case for using R over T-SQL—the Chi Square test is built in, whereas you have to roll your own T-SQL code. Mala does show you how to do this from within SQL Server R Services as well.
Comments closedKendra Little has a couple queries to force deadlocks in the WideWorldImporters database:
SQL Server’s deadlock manager woke up, looked around, and saw that our two session windows were stuck. They each were requesting locks that the other session wouldn’t give up– and if the deadlock manager didn’t break the deadlock, they’d be stuck there forever.
I didn’t set the deadlock priority on any of my transactions, so the deadlock manager picked the session that it thought would be the least work to roll back– and it became the victim.
Read on for the scripts and also some hints to help you learn more about deadlocks.
Comments closedBrent Ozar introduces a new website:
It’s a free community service. We hope you love it as much as we do, especially all the cool new execution plan icons by our illustrator, Eric Larsen.
Down the road, we’re thinking about adding logins (so you can see past plans you’ve submitted), execution plan advice, image and HTML downloads (so you can embed the plan in your own blog or report), zooming, and more.
Check out the Paste The Plan website.
Comments closedDavid Klee shows that you can put an AFTER trigger on a memory-optimized table in SQL Server 2016:
SQL Server 2016 supports AFTER triggers! I could find no good example of how to do this with a project I’m working on, so I figured out how to make this work. The following before and after screenshots are from a SQL Server 2016 instance and the DVDStore3 package. I modified a trigger to work with In-Memory OLTP.
Click through to see the code.
Comments closedJonathan Kehayias shows where to find older cumulative updates:
However, to my dismay that link took me to the download link for SQL Server 2014 SP1 CU8 and not to CU7 as I was expecting. So I tried other SP1 CU links and they all redirect to the CU8 download page. Slightly irritated I decided to send a Skype IM to Glenn (@GlennAlanBerry|Blog) what was going on because he keeps up with every update Microsoft publishes for SQL Server. Glenn told me that Microsoft’s recommendation and preference is for people to install the latest CU so the KB articles now link to the latest CU download page. That doesn’t really help me with adding a failed FCI node back into a FCI that is on CU7, so Glenn offered to share the CU7 file with me by Dropbox.
It turns out that I didn’t need Glenn to share the file with me, I needed to read the information on the KB article closer and pay attention.
Read on to find out where you can find the CU archives.
Comments closedReza Rad shows how to tell a data story using a combination of Powerpoint and Power BI:
You can see here that I’ve added a title for this slide in Power Point, and also a Textbox with text “Psychology has the most sales”. Yes, with this method you can add commentary to Power BI reports and dashboards, you can tell the story behind the data with integration of Power BI and Power Point. very simple feature but really useful.
Under each Power BI tile in Power Point there will be a link to Power BI
Read the whole thing.
Comments closedVikash Selvin shows how to secure instances of Elasticsearch and Kibana:
The most popular options for securing Elasticsearch and Kibana are compared in the table below.
Shield is a security plugin developed by the same company that developed Elasticsearch. It allows you to easily protect this data with a username and password while simplifying your architecture. Advanced security features like encryption, role-based access control, IP filtering, and auditing are also available when you need them.
NGINX is an open source web server. It can act as a proxy server and can do load balancing, among other things. In combination with LUA and external scripts, it can be used for securing Elasticsearch and Kibana. We will be using this approach in this tutorial.
Searchguard is an open source alternative for Shield. It provides almost all the same functionalities as Shield, except for some features like LDAP authentication. However, these features are available in the paid variant.
Click through for a detailed NGINX setup.
Comments closed