Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Saturday, March 31, 2018

Transaction log backup in Logshipping

SQLServerCentral » Latest topics
Transaction log backup in Logshipping
Hi,
Can any one help me with an answer pls.
I have my normal housekeeping fullbackup and transaction log backup ,running under agent job.

Now I have a requirement to make one Db under log shipping.So My question,

1)Does my existi

Friday, March 30, 2018

The cloud continues to drive network evolution

Network World Data Center
The cloud continues to drive network evolution
The cloud continues to drive network evolution

It’s fair to say that there has never been a bigger driver of network evolution than the cloud. The reason for this is the cloud is a fundamentally different kind of compute paradigm, as it enables applications, data and architecture changes to be done seemingly instantly. Cloud-native infrastructure is what enables mobile app developers to roll out new versions daily if they so choose.

The cloud is network-centric

Another fact about the cloud is that it is a network-centric compute model, so a poorly performing network leads to equally poorly performing applications. A lack of network agility means DevOps teams need to sit around twiddling their thumbs while network operations make changes to the network. 

To read this article in full, please click here

Generate a unique number for a combination

SQLServerCentral » Latest topics
Generate a unique number for a combination
How do you generate unique number based on  a Loannumber , Date columns

Example

Declare @loannumber Int = 1234565
,@date Date = '12-01-2017'


Declare @test table
(
LOannumber int
,Startdate date
-

Exam 70-462: Using Azure for the Practice Setup

SQLServerCentral.com Articles
Exam 70-462: Using Azure for the Practice Setup

A step-by-step guide to creating a practice setup for the 70-462 exam using Azure virtual machines.

sqlmonitor How to fix SQL Server disk I/O bottlenecks (without a hammer)
In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.

Comic for 2018.03.30

RSSMix.com Mix ID 8239024
Comic for 2018.03.30
New Cyanide and Happiness Comic

Thursday, March 29, 2018

Nvidia packs 2 petaflops of performance in a single compact server

Network World Data Center
Nvidia packs 2 petaflops of performance in a single compact server
Nvidia packs 2 petaflops of performance in a single compact server

At its GPU Technology Conference this week, Nvidia took the wraps off a new DGX-2 system it claims is the first to offer multi-petaflop performance in a single server, thus greatly reducing the footprint to get to true high-performance computing (HPC).

DGX-2 comes just seven months after the DGX-1 was introduced, although it won’t ship until the third quarter. However, Nvidia claims it has 10 times the compute power as the previous generation thanks to twice the number of GPUs, much more memory per GPU, faster memory, and a faster GPU interconnect.

[ Learn how server disaggregation can boost data center efficiency. | Get regularly scheduled insights by signing up for Network World newsletters. ]

The DGX-2 uses a Tesla V100 CPU, the top of the line for Nvidia’s HPC and artificial intelligence-based cards. With the DGX-2, it has doubled the on-board memory to 32GB. Nvidia claims the DGX-2 is the world’s first single physical server with enough computing power to deliver two petaflops, a level of performance usually delivered by hundreds of servers networked into clusters.

To read this article in full, please click here

SQL Server Authenticated Users, why are we still using them?

SQLServerCentral » Latest topics
SQL Server Authenticated Users, why are we still using them?
Comments posted to this topic are about the item [B]SQL Server Authenticated Users, why are we still using them?[/B]

Adaptive Query Processing – Batch Mode Memory Grant Feedback

SQLServerCentral » Latest topics
Adaptive Query Processing – Batch Mode Memory Grant Feedback
Comments posted to this topic are about the item [B]Adaptive Query Processing – Batch Mode Memory Grant Feedback[/B]

Comic for 2018.03.28

RSSMix.com Mix ID 8239024
Comic for 2018.03.28
New Cyanide and Happiness Comic

Scripting All Objects from SSMS in to a VCS

SQLServerCentral.com Articles
Scripting All Objects from SSMS in to a VCS

A short tutorial on scripting objects in SSMS.

Wednesday, March 28, 2018

Are the posted questions getting worse?

SQLServerCentral » Latest topics
Are the posted questions getting worse?
Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in charge of something who was asking how to take a database backup and restore it on another server. It seems like the general feeling of a lot

Comic for 2018.03.27

RSSMix.com Mix ID 8239024
Comic for 2018.03.27
New Cyanide and Happiness Comic

Stairway to U-SQL Level 21: Exporting Data with Azure Data Factory

SQLServerCentral.com Articles
Stairway to U-SQL Level 21: Exporting Data with Azure Data Factory

Learn how you can move data from your Data Lake to Azure SQL Database with Azure Data Factory.

sqlmonitor How to fix SQL Server disk I/O bottlenecks (without a hammer)
In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.

Tuesday, March 27, 2018

How server disaggregation could make cloud data centers more efficient

Network World Data Center
How server disaggregation could make cloud data centers more efficient
How server disaggregation could make cloud data centers more efficient

The growth in cloud computing has shone a spotlight on data centers, which already consume at least 7 percent of the global electricity supply and growing, according to some estimates. This has led the IT industry to search for ways of making infrastructure more efficient, including some efforts that attempt to rethink the way computers and data centers are built in the first place.

To read this article in full, please click here

(Insider Story)

SQL Server 2016 Availability Group - Automatic Seeding with SSMS 17.x

SQLServerCentral.com Articles
SQL Server 2016 Availability Group - Automatic Seeding with SSMS 17.x

In SQL Server 2016 the availability group automatic seeding functionality is implemented. This article will detail the steps to use of SSMS with automatic seeding and its limitations.

Today's Random Word!

SQLServerCentral » Latest topics
Today's Random Word!
HI When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene or a word running through your mind... Jump on that word... And. Post it here by it's thumbs! :hat: Quickly! Before it becomes a number!

Monday, March 26, 2018

IDG Contributor Network: Are you ready for the GDPR in May?

Network World Data Center
IDG Contributor Network: Are you ready for the GDPR in May?
IDG Contributor Network: Are you ready for the GDPR in May?

[Note: The author of this article is not a lawyer and this article should not be considered legal advice. Please consult a privacy specialist.]

The basic news

The GDPR covers all personal data your company stores on data subjects in the EU – whether or not your company has nexus in the EU. Personal data is defined as data that can be used to identify a person.  It’s similar to the concept of personally identifiable information (PII) that we have in the US, but it is broader. PII typically includes actual identifying elements like your name, social security number, and birthday, focusing mainly on the data required to fake your identity with a lender. Personal data includes what the US calls PII, plus any data that can be used to identify you in any way, which includes things as basic as an email address, online personality (e.g. twitter handle), or even the IP address where you transmitted a message from.

To read this article in full, please click here

What next????

SQLServerCentral » Latest topics
What next????
I have  total 5 year exp In Sql, ssrs, ssis, ssas(3 year). 
I was thinking what to fo for next. 
Learning new reporting tools(currently looking into it)  
Deep learning of data modeling and dataware house concepts?.&nb

Import bacpac error in SQL Azure

SQLServerCentral » Latest topics
Import bacpac error in SQL Azure
Hi Everyone,

I'm trying to import a bacpac (from an existing SQL Azure database) on to the same SQL Azure Server (under a different name) and I'm getting the following error message:

TITLE: Microsoft SQL Server Management Studio---------

SQL Server 2017 for Linux first impression

SQLServerCentral.com Articles
SQL Server 2017 for Linux first impression

Microsoft has released a version of SQL Server 2017 for Linux.

Comic for 2018.03.26

RSSMix.com Mix ID 8239024
Comic for 2018.03.26
New Cyanide and Happiness Comic

Sunday, March 25, 2018

advice on revision and updating SQL to get back to work after a gap

SQLServerCentral » Latest topics
advice on revision and updating SQL to get back to work after a gap
Hi Friends,
I am looking to get back to work after a long gap of 3 years. I have less work experience just 2 years.
please suggest me ways to update /revise my SQL skills and be prepared for interviews.
Thanks,
Siri

Comic for 2018.03.25

RSSMix.com Mix ID 8239024
Comic for 2018.03.25
New Cyanide and Happiness Comic

Saturday, March 24, 2018

So Many Choices with SQL Server

SQLServerCentral » Latest topics
So Many Choices with SQL Server
Comments posted to this topic are about the item [B]So Many Choices with SQL Server[/B]

Comic for 2018.03.24

RSSMix.com Mix ID 8239024
Comic for 2018.03.24
New Cyanide and Happiness Comic

Friday, March 23, 2018

IBM, HPE tout new A.I.-oriented servers

Network World Data Center
IBM, HPE tout new A.I.-oriented servers
IBM, HPE tout new A.I.-oriented servers

IBM and Hewlett Packard Enterprise this week introduced new servers optimized for artificial intelligence, and the two had one thing in common: Nvidia technology.

HPE this week announced Gen10 of its HPE Apollo 6500 platform, running Intel Skylake processors and up to eight Pascal or Volta Nvidia GPUs connected by NVLink, Nvidia’s high-speed interconnect.

A fully loaded V100s server will get you 66 peak double-precision teraflops of performance, which HPE says is three times the performance of the previous generation.

The Apollo 6500 Gen10 platform is aimed at deep-learning workloads and traditional HPC use cases. The NVLink technology is up to 10 times faster than PCI Express Gen 3 interconnects.

To read this article in full, please click here

Somebody Help! - T-SQL syntax help.

SQLServerCentral » Latest topics
Somebody Help! - T-SQL syntax help.

Here is what I need. I have s start date and a end date.
What I need is to break this down into several intervals ( monthly ) 
So I was able to just get the very first interval.

May you p

Comic for 2018.03.23

RSSMix.com Mix ID 8239024
Comic for 2018.03.23
New Cyanide and Happiness Comic

Getting query text from SSMS into a CSV with PowerShell

SQLServerCentral.com Articles
Getting query text from SSMS into a CSV with PowerShell

You have times where you need to copy/paste something out of SSMS' grid view results pane that has a carriage return in it. Trying to copy/paste that data into Excel can be a headache and cause you to waste precious time reformatting. This just offers a tidbit of PowerShell code to help.

Parent / Child tables - SELECT QUERY to bring child data records into parent record

SQLServerCentral » Latest topics
Parent / Child tables - SELECT QUERY to bring child data records into parent record
I have two tables, one with Summary/basic data, the other with detail data multiple records pertaining to each record in the Parent table. 
The number of records  in the detail table for each parent record varies by Site.  I need to se

Comic for 2018.03.21

RSSMix.com Mix ID 8239024
Comic for 2018.03.21
New Cyanide and Happiness Comic

Thursday, March 22, 2018

Top 6 Features in Windows Server 2019

Network World Data Center
Top 6 Features in Windows Server 2019
Top 6 Features in Windows Server 2019

Because Microsoft has shifted to a more gradual upgrade of Windows Server, many of the features that will become available with Windows Server 2019 have already been in use in live corporate networks, and here are half a dozen of the best.

[ Check out REVIEW: VMware’s vSAN 6.6 and hear IDC’s top 10 data center predictions . | Get regularly scheduled insights by signing up for Network World newsletters. ] Enterprise-grade hyperconverged infrastructure (HCI)

With the release of Windows Server 2019, Microsoft rolls up three years of updates for its HCI platform. That’s because the gradual upgrade schedule Microsoft now uses includes what it calls Semi-Annual Channel releases – incremental upgrades as they become available. Then every couple of years it creates a major release called the Long-Term Servicing Channel (LTSC) version that includes the upgrades from the preceding Semi-Annual Channel releases.

To read this article in full, please click here

The DefaultBufferMaxRows and DefaultBufferSize Properties in SSIS

SQLServerCentral.com Articles
The DefaultBufferMaxRows and DefaultBufferSize Properties in SSIS

This article shows how DefaultBufferMaxRows and DefaultBufferSize properties can be used to improve dataflow task performance.

Index statistics update with full scan.

SQLServerCentral » Latest topics
Index statistics update with full scan.
Can anyone help me to sort this out , D

Wednesday, March 21, 2018

Consider using [NOT] EXISTS instead of [NOT] IN (subquery)

SQLServerCentral.com Articles
Consider using [NOT] EXISTS instead of [NOT] IN (subquery)

The query optimizer now treats EXISTS and IN the same way, whenever it can, so you’re unlikely to see any significant performance differences. Nevertheless, you need to be cautious when using the NOT IN operator if the subquery’s source data contains NULL values. If so, you should consider using a NOT EXISTS operator instead of NOT IN, or recast the statement as a left outer join.

Dynamic Column

SQLServerCentral » Latest topics
Dynamic Column
I am trying to figure out how to take the following and dynamically generate  a new column for every person and split that has the same ID so that it reads across vs up and down. No matter what I try I can't get the output the way I need it.

Tuesday, March 20, 2018

Capturing Power BI queries using DAX Studio

SQLblog.com - The SQL Server blog spot on the web
Capturing Power BI queries using DAX Studio

I recently published a new blog post on SQLBI.

You can read it at this link: https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/.

Windows Server 2019 embraces hybrid cloud, hyperconverged data centers, Linux

Network World Data Center
Windows Server 2019 embraces hybrid cloud, hyperconverged data centers, Linux
Windows Server 2019 embraces hybrid cloud, hyperconverged data centers, Linux

Microsoft is set to make Windows Server 2019 generally available in the second half of the year, opening up access to its preview build through its Insiders program now and targeting data centers with new features to handle hybrid cloud setups and hyperconverged infrastructure.

The next version of Windows Server also adds new security features and enhances support for containers and Linux.

[ Check out REVIEW: VMware’s vSAN 6.6 and hear IDC’s top 10 data center predictions . | Get regularly scheduled insights by signing up for Network World newsletters. ]

If you want to check out the release for yourself, sign up for the Insiders program.

To read this article in full, please click here

Comic for 2018.03.20

RSSMix.com Mix ID 8239024
Comic for 2018.03.20
New Cyanide and Happiness Comic

Issue with SELECT after creating a CTE SOLVED!! User error

SQLServerCentral » Latest topics
Issue with SELECT after creating a CTE SOLVED!! User error
not fluent in CTE's but I thought i did this right. I get an Error Near SELECT for the select after the CTE.  Thoughts? thanks  (Sorry, Webpage doesnt give me a SQL option below . . . thanks 

I deleted the SQL, i found my problem,

FPGA maker Xilinx aims range of software-programmable chips at data centers

Network World Data Center
FPGA maker Xilinx aims range of software-programmable chips at data centers
FPGA maker Xilinx aims range of software-programmable chips at data centers

As data centers are called upon to handle an explosion of unstructured data fed into a variety of cutting-edge applications, the future for FPGAs looks bright.

That’s because FPGAs, or field programmable gate arrays, are essentially chips that can be programmed, after manufacturing, to act as custom accelerators for workloads including machine-learning, complex data analysis, video encoding, and genomics – applications that have far-reaching consequences for communications, networking, health care, the entertainment industry and many other businesses.

[ Check out REVIEW: VMware’s vSAN 6.6 and hear IDC’s top 10 data center predictions . | Get regularly scheduled insights by signing up for Network World newsletters. ]

Such applications lend themselves to parallel processing, an important feature of FPGAs, which can also be reconfigured on the fly to handle new features as the nature of these workloads evolve.

To read this article in full, please click here

Redgate’s support for Azure SQL Database Managed Instances

SQLServerCentral.com Articles
Redgate’s support for Azure SQL Database Managed Instances

Last week Microsoft released the public preview of Azure SQL Database Managed Instances – an exciting new option for running SQL Server workloads in the cloud. This blog post explains what they are, and how Redgate's SQL Toolbelt supports them.

Set-Based String Splitting table function

SQLServerCentral » Latest topics
Set-Based String Splitting table function
Comments posted to this topic are about the item [B]Set-Based String Splitting table function[/B]

Comic for 2018.03.19

RSSMix.com Mix ID 8239024
Comic for 2018.03.19
New Cyanide and Happiness Comic

Monday, March 19, 2018

FPGA maker Xilinx aims range of software programmable chips at data centers

Network World Data Center
FPGA maker Xilinx aims range of software programmable chips at data centers
FPGA maker Xilinx aims range of software programmable chips at data centers

As data centers are called upon to handle an explosion of unstructured data fed into a variety of cutting-edge applications, the future for FPGAs looks bright.

That’s because FPGAs, or field programmable gate arrays, are essentially chips that can be programmed, after manufacturing, to act as custom accelerators for workloads including machine-learning, complex data analysis, video encoding, and genomics – applications that have far-reaching consequences for communications, networking, health care, the entertainment industry and many other businesses.

Such applications lend themselves to parallel processing, an important feature of FPGAs, which can also be reconfigured on the fly to handle new features as the nature of these workloads evolve.

To read this article in full, please click here

OPENROWSET and "Could not find installable ISAM"

SQLServerCentral » Latest topics
OPENROWSET and "Could not find installable ISAM"
Hi Folks,

I have a problem with regards to querying an Excel Spreadsheet using not only OPENROWSET but also OPENDATASOURCE.

I am using SQL Server 2016, the spreadsheet is Excel 2010.

This is the OPENROWSET statement:

The top 7 benefits of DevOps for CIOs

SQLServerCentral.com Articles
The top 7 benefits of DevOps for CIOs

When CEOs consider the benefits of DevOps and whether or not they should introduce it, their viewpoint will be influenced by their ongoing concerns with lowering costs and increasing revenues. As a result, factors like gaining a faster time to market and creating higher quality products will be top of the agenda. It’s a different story for CIOs because their focus is more on processes that can increase the throughput of the IT department, or how skilled IT staff can be recruited and retained.

Comic for 2018.03.18

RSSMix.com Mix ID 8239024
Comic for 2018.03.18
New Cyanide and Happiness Comic

Sunday, March 18, 2018

Message from database

SQLServerCentral » Latest topics
Message from database
I like to use MS SQL Server databases. In our company, we have some huge very valuable database. Some hours ago, we've started to transfer it from one machine to another. Now we've almost done. But one of the datab

Saturday, March 17, 2018

PASS Marathon GDPR Edition: Recordings now available!

SQLblog.com - The SQL Server blog spot on the web
PASS Marathon GDPR Edition: Recordings now available!
You have certainly already heard about the new European Regulation 679/2016, better known as GDPR, on the protection of personal data.
 
GDPR is the acronym of General Data Protection Regulation, companies and professionals are required, by May 25 (2018) to comply with the new rules on personal data protection.

"The aim of the GDPR is to protect all EU citizens from privacy and data breaches in an increasingly data-driven world that is vastly different from the time in which the 1995 directive was established. Although the key principles of data privacy still hold true to the previous directive, many changes have been proposed to the regulatory policies; the key points of the GDPR as well as information on the impacts it will have on business can be found below" - https://www.eugdpr.org/key-changes.html 

Were you unable to attend the PASS Marathon in partnership with Redgate to understand what the GDPR entails? Don't worry, the sessions of the event PASS Marathon GDPR Edition (held the last March 2018 on 13th) were recorded and now they are available for online streaming!
 

If you have missed one session or the entire event, you can view or review your preferred talk.
 
Each video is available on the schedule page of the event.
 
Enjoy the videos! 

Comic for 2018.03.17

RSSMix.com Mix ID 8239024
Comic for 2018.03.17
New Cyanide and Happiness Comic

If only the US would follow ...

SQLServerCentral » Latest topics
If only the US would follow ...
Comments posted to this topic are about the item [B]If only the US would follow ...[/B]

What to do if your cloud provider stops offering its services

Network World Data Center
What to do if your cloud provider stops offering its services
What to do if your cloud provider stops offering its services

What would your organization do if your cloud provider were to go out of business? What happens if your cloud provider suddenly stops offering critical services that your organization requires for its business to function properly? Businesses need to start asking these important questions and develop plans to address these scenarios.

The cloud is a new market that continues to grow, and there are more small players offering their services. According to Gartner, Cloud System Infrastructure Services (IaaS) are expected to grow from $45.8 billion in revenue in 2018 to $72.4 billion in 2020. As the market matures, it's only natural that some of these organizations will disappear or stop offering certain services. In 2013, Nirvanix stopped offering it cloud services and gave customers only two weeks’ notice to move their data off of their platform.

To read this article in full, please click here

Friday, March 16, 2018

SSIS tutoring

SQLServerCentral » Latest topics
SSIS tutoring
Does anyone know where I can get examples, resources or a good books for SSIS?

Another selling point of bare-metal cloud providers: local service

Network World Data Center
Another selling point of bare-metal cloud providers: local service
Another selling point of bare-metal cloud providers: local service

Several things make bare-metal cloud providers appealing compared with traditional cloud providers, which operate in a virtualized environment. Bare-metal providers give users more control, more access to hardware, more performance, and the ability to pick their own operating environment.

There's another interesting angle, as articulated by Martin Blythe, a research fellow with Gartner. He maintains that bare-metal providers appeal to small and mid-sized businesses (SMBs) because those companies are often small, local players, and SMBs looking for something more economical than hosting their own data center often want to keep the data center nearby.

To read this article in full, please click here

Your Thoughts On In-line SQL

SQLServerCentral » Latest topics
Your Thoughts On In-line SQL
Comments posted to this topic are about the item [B]Your Thoughts On In-line SQL[/B]

Comic for 2018.03.16

RSSMix.com Mix ID 8239024
Comic for 2018.03.16
New Cyanide and Happiness Comic

Stairway to U-SQL Level 19: Azure Data Lake Metadata with PowerShell

SQLServerCentral.com Articles
Stairway to U-SQL Level 19: Azure Data Lake Metadata with PowerShell

Need to inspect your Data Lake objects and files? Want to automate the process? Find out how with PowerShell.

Thursday, March 15, 2018

SSMS: First connection to DBMS takes over 15 minutes

SQLServerCentral » Latest topics
SSMS: First connection to DBMS takes over 15 minutes
So I have come across an odd issue on my workstation that I was hoping someone on here might be able to provide some insight on. The issue I am having is that when I start a new instance of SSMS it is taking over 15 minutes to establish the first conne

Comic for 2018.03.14

RSSMix.com Mix ID 8239024
Comic for 2018.03.14
New Cyanide and Happiness Comic

SQL Provision adds fully integrated data masking

SQLServerCentral.com Articles
SQL Provision adds fully integrated data masking

SQL Provision launched in January, offering users blazingly fast database copying, with a light storage footprint, centralized management, and the ability to mask any sensitive data, prior to distribution. This new release takes compliant provisioning one step further, by integrating data masking directly into SQL Clone’s image creation process, rather than running it as a separate step prior to the image creation.

Wednesday, March 14, 2018

My #AWSsummit keynote liveblog

SQLblog.com - The SQL Server blog spot on the web
My #AWSsummit keynote liveblog

The company I work for, Perion, chose Amazon Web Services as a main cloud provider for managing and operating our applications. These days I am learning how to manage databases and data related flows in the AWS cloud.

Which is the reason I have attended the AWS summit in Tel Aviv today.

Today’s AWS summit was the first out of the series of AWS summits held in major cities around the world. There were ~ 5000 attendees today, 25 technical sessions and it was sponsored by 33 AWS partners. Most sessions that I have attended today had a lot of sponsor content mixed with technical not-too-deep dive into various AWS services. 

Sessions were divided into 5 tracks, led by AWS Solution Architects and Sponsors representatives:

Big data & Analytics sessions on data ingestion, data transformation and data analysis using AWS services
AI and Deep Learning – sessions on AWS offerings for data enrichment and learning models
Innovate – Rapid Application Development services
Cloud operations – sessions on DevOps methodologies and tools
Let’s start - for those who starts their journey into the AWS cloud

I have really enjoyed the keynote by Dr. Werner Vogels, Amazon CTO. The keynote hall was already fully packed when I have arrived, and I had to watch the keynote video stream from the second hall. The sound was awesome but the person who was operating the camera wasn’t well at his job. Half of the slides could not be seen; the focus was all the time on the speaker.

Dr. Werner have talked about Amazon revenue run rate, which is near $20 billion dollars  ( this forbes.com article says $16 billion, Microsoft has $16.7 billion, IBM $15.8 billion). AWS have millions of active customers and their pace of innovations (amount of the unique services per year) grows at very high pace:

24 during 2008
48 during 2009
61 during 2010
82 during 2011
159 during 2012
280 during 2013
516 during 2014
722 during 2015
1017 during 2016
1403 during 2017

Amazon for 7 consecutive years named as a Leader in Gartner’s Infrastructure as a Service (IaaS) Magic Quadrant.

Dr. Werner have talked about how infrastructure and software vendors used to tell us how to develop software. These days, in the cloud, we have as many tools as we need to make our development tailored to our needs.

Modern applications are continuously evolving. They have more than web content, they are using micro services architecture and are api-based. Everything is programmable, many have a smart connectivity, push notifications and responsive design. We used to have 1 deployment a week, now we have 50 deployments a day.

There were many awesome examples of the AWS customers during the keynote. One of them was the cloud infrastructure behind the iRobot:

 

(Image source : https://aws.amazon.com/solutions/case-studies/irobot/)

Dr. Werner have mentioned how Netflix are making use of Machine Learning to build smarter applications. 75% of the Netflix videos were viewed after the recommendation made by the recommendation engine. He has also mentioned the Pinterest, one of the world’s largest visual bookmarking tools, where all images go through Machine Learning process to get a better grip on visual search. Another cool examples were the boxing gloves that check the punch speed and the punch intensity, the helmet that analyses the pilot’s emotions and soccer and baseball video ingestion that uses Machine Learning to help coaches to understand how the team can do better at the next game.

Machine Learning can be used in many more use-cases:

Shopping advises
Customer problem detection
Product modeling
Production substitutes
Customer adoption models
Sales lead ranking

Dr. Werner have talked about the modern data architectures and their 10 main characteristics: reliable data ingestion, preservation of source data, lifecycle management, metadata capture, security, self-service discovery, data quality, analytics, orchestration and capturing the data changes. He has mentioned that 60000+ databases already have been migrated into the AWS cloud from private datacenters. He has also talked about Aurora, the fast-growing database service. The Aurora data is being copied into 3 regions and has up and down auto-scaling capacity. For example, Expedia that has 4000 writes / 5000 reads per second into the Aurora database.

I will skip the keynote part where Dr. Werner have talked about rapid application development, serverless architecture, code services, kubernetes and application services – that is not my cup of tea.

There was an awesome demo of Trax, the company that uses innovative image recognition technology to help retail stores to sort out their shelves and are using Artificial Intelligence to unlock business opportunities. As a next stage of their solution, they are planning to use robots to take pictures inside stores which is very cool.

Another great demo was about Flytrax, first drone based food delivery service.  Drones are super-fast, the can fly up to 60 km/h, affordable, not impacted by the traffic and can easily reach almost any location within a few minutes instead of driving for a few hours. Unfortunately, this service is not available in Israel yet.

Great keynote, #awssummit !

Yours,

Maria

Query to Excel Stored Procedure

SQLServerCentral.com Articles
Query to Excel Stored Procedure

Transform your query result into an Excel file using this technique.

The Last iPhone

SQLServerCentral » Latest topics
The Last iPhone
Comments posted to this topic are about the item [B]The Last iPhone[/B]

Tuesday, March 13, 2018

Stairway to U-SQL Level 5: Databases and Tables in Azure Data Lakes with U-SQL

SQLServerCentral » Latest topics
Stairway to U-SQL Level 5: Databases and Tables in Azure Data Lakes with U-SQL
Comments posted to this topic are about the item [B]Stairway to U-SQL Level 5: Databases and Tables in Azure Data Lakes with U-SQL[/B]

A new telepresence robot takes the stage

Network World Data Center
A new telepresence robot takes the stage
A new telepresence robot takes the stage

Ava Robotics, a startup with strong technical ties to iRobot, just announced its telepresence robot. Her name is Ava, and she’s likely to win a lot of hearts.

For one thing, Ava is quite perceptive, using video technology from Cisco and integrating with Cisco Spark (which provides tools for team messaging, online meetings, and white boarding). Ava is also quite friendly. She allows her users to participate in remote meetings, wander down hallways at other facilities while chatting with colleagues, and enjoy face-to-face discussions with people who may physically be thousands of miles away.

Also read: Customer reviews: Top Remote Access Tools

Telepresence robots provide a lot of benefits to companies that are spread across many locations — especially those spanning continents — or with staff who work from home. They make work relationships considerably more productive — even for individuals who may have never met in person. Carrying on casual conversations and checking remote data centers and manufacturing facilities (sometimes safer than being there in person) can make huge differences in how staffs coordinate and get important work done.

To read this article in full, please click here

Insert a data in MS Sql Server Managment studio thorugh php

SQLServerCentral » Latest topics
Insert a data in MS Sql Server Managment studio thorugh php
Hi,
I am using MS SQL server management through PHP. I have already connection successful but the problem is when I am going to insert data into a table through Excel sheet with the help of PHP. So it's showing me an error: "Count field

Comic for 2018.03.13

RSSMix.com Mix ID 8239024
Comic for 2018.03.13
New Cyanide and Happiness Comic

Scripting Environments in SSIS

SQLServerCentral.com Articles
Scripting Environments in SSIS

Demo and script on how to script out SSIS Environments and their associated variables

Monday, March 12, 2018

Upgrade SQL Server 2017 OS Question.

SQLServerCentral » Latest topics
Upgrade SQL Server 2017 OS Question.
We are planning to upgrade our SQL server environment to 2017. 
So which will the best OS 2012 vs 2016?

What are the advantages and new features that SQL 2017 will be benefited on running on 2016 Windows Server OS.
Mostly these SQL s

Staying Current on Power BI Dashboards

SQLServerCentral.com Articles
Staying Current on Power BI Dashboards

Power BI Dashboards can be kept current using simple DAX formulas in your data models. Save yourself time and energy by understanding how dashboard tiles work on PowerBI.com and what can be done to set your dashboards to a current period.

Sunday, March 11, 2018

TDE Trusted CA Vs. Self-Signed Certificate

SQLServerCentral » Latest topics
TDE Trusted CA Vs. Self-Signed Certificate
Hello,
We have a customer who wants us to TDE on their databases.  I need to be able to explain at a very top level, the advantages and/or disadvantages of generating the certificates and keys in SQL (self-signed) and using a certificate generate

Comic for 2018.03.11

RSSMix.com Mix ID 8239024
Comic for 2018.03.11
New Cyanide and Happiness Comic

Saturday, March 10, 2018

SQL Azure instance doubt

SQLServerCentral » Latest topics
SQL Azure instance doubt
Hi All,

Can we change the port no of Azure Sql Instance? Today, someone was asking me. I thought Azure instances is completely managed by Microsoft right? We will just use a database right? if that is the case, can we change the port number? if i

Comic for 2018.03.10

RSSMix.com Mix ID 8239024
Comic for 2018.03.10
New Cyanide and Happiness Comic

Is Security Catching On?

SQLServerCentral » Latest topics
Is Security Catching On?
Comments posted to this topic are about the item [B]Is Security Catching On?[/B]

Friday, March 9, 2018

Stairway to Columnstore Indexes Level 3: Building The Columnstore

SQLServerCentral.com Articles
Stairway to Columnstore Indexes Level 3: Building The Columnstore

The performance increase columnstore indexes grant when reading data from the index is offset by the expensive process required to build the index. In this Stairway level, Hugo Kornelis walks you through the steps SQL Server takes when building (or rebuilding) a columnstore index.

Default CONTEXT_INFO()

SQLServerCentral » Latest topics
Default CONTEXT_INFO()
Comments posted to this topic are about the item [B]Default CONTEXT_INFO()[/B]

Thursday, March 8, 2018

VMware tackles complexity of multi-cloud environments

Network World Data Center
VMware tackles complexity of multi-cloud environments
VMware tackles complexity of multi-cloud environments

VMware has expanded its portfolio of cloud tools to help enterprises improve the manageability of their public cloud and on-premises environments. At the same time, VMware announced the first global expansion of VMware Cloud on AWS, its joint hybrid cloud service with Amazon Web Services.

Complexity is on the rise for enterprises as they expand their use of cloud computing – which often is not limited to a single cloud provider. VMware estimates that nearly two-thirds of companies will use two or more cloud service providers in addition to their on-premises data centers.

To read this article in full, please click here

Low Latency Memory

SQLblog.com - The SQL Server blog spot on the web
Low Latency Memory
For the last twenty years, the standard practice has been to scale server performance with multi-processor (MP) systems. What is not widely understood is that after processors integrated the memory controller, the initial step from single processor to 2-way has only moderate scaling due to the introduction of non-uniform memory access (NUMA) in the MP system architecture. Scaling versus cores within a single processor however, can be excellent. The new practice should now be to employ single processor...(read more)

Always Encrypted - High Volume OLTP????

SQLServerCentral » Latest topics
Always Encrypted - High Volume OLTP????
Has anyone implemented Always Encrypted on a high volume OLTP instance or know anyone that has?

We are going through the process of vetting Always Encrypted now. It would be nice to h

How to build a DevOps roadmap to kickstart your digital transformation journey

SQLServerCentral.com Articles
How to build a DevOps roadmap to kickstart your digital transformation journey

By harnessing the concept of agility to a methodology that enables constant software innovation, DevOps allows organizations to respond dynamically to changing market conditions and rising customer expectations.

Wednesday, March 7, 2018

Comic for 2018.03.07

RSSMix.com Mix ID 8239024
Comic for 2018.03.07
New Cyanide and Happiness Comic

Generate UserName from Existing table

SQLServerCentral » Latest topics
Generate UserName from Existing table
Hi Guys,

I have one new challenge to generate UserName from the table, below i provide some sample data

[code language="sql"]
CREATE TABLE #TEMP
(ID VARCHAR(10),
FIRSTNAME VARCHAR(50)

Cisco bolsters Tetration for better cloud, workload security

Network World Data Center
Cisco bolsters Tetration for better cloud, workload security
Cisco bolsters Tetration for better cloud, workload security

Cisco this week expanded its Tetration Analytics system to let users quickly detect software vulnerabilities and more easily manage the security of the key components in their data centers.

Introduced in 2016, the Cisco Tetration Analytics system gathers information from hardware and software sensors and analyzes the information using big data analytics and machine learning to offer IT managers a deeper understanding of their data center resources. The idea behind Tetration includes the ability to dramatically improve enterprise security monitoring, simplify operational reliability and move along application migrations to Software Defined Networking.

To read this article in full, please click here

How to Survive as a Lone DBA

SQLServerCentral.com Articles
How to Survive as a Lone DBA

Database administrators have enormous responsibility whether they manage one or hundreds of servers. Monica Rathbun tells us how she survived as the Lone DBA for 56 database servers for over a decade. While many DBAs work on teams instead of alone, she has great advice for all.

Comic for 2018.03.06

RSSMix.com Mix ID 8239024
Comic for 2018.03.06
New Cyanide and Happiness Comic

Datatype Change

SQLServerCentral » Latest topics
Datatype Change
Changed one of the existing column datatype from varchar(250) to nvarchar(250) but the column still showing arabic characters as ??

How can i resolve this?

Tuesday, March 6, 2018

Comic for 2018.03.05

RSSMix.com Mix ID 8239024
Comic for 2018.03.05
New Cyanide and Happiness Comic

How to Suck at Database Administration

SQLServerCentral.com Articles
How to Suck at Database Administration

Tara Kizer outlines 15 telltale signs that you aren't a very good senior DBA.

XML parsing: semicolon expected

SQLServerCentral » Latest topics
XML parsing: semicolon expected
I know the "XML parsing: semicolon expected" error is a data error, and not a SQL error.  The first error I am trying to get rid of is the one about DTD subsets, so I am using CONVERT(xml, xml_data, 2), but then I get this:
Msg 9411, Level 1

Monday, March 5, 2018

Comic for 2018.03.04

RSSMix.com Mix ID 8239024
Comic for 2018.03.04
New Cyanide and Happiness Comic

"But It Worked in Development!" - 3 Hard SQL Server Performance Problems

SQLServerCentral.com Articles
"But It Worked in Development!" - 3 Hard SQL Server Performance Problems

You’ve been performance tuning queries and indexes for a few years, but lately, you’ve been running into problems you can’t explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heavy load or concurrency, so they’re very hard to detect in a development environment.

Error when having 2 CTEs

SQLServerCentral » Latest topics
Error when having 2 CTEs
This code results in
Msg 102, Level 15, State 1, Line 29
Incorrect syntax near ','.    That is the between the CTEs. I copied syntax from another report that i wrote that works.  Thoughts?

Sunday, March 4, 2018

Need advice on how to process Access DBs with different table structures into SQL Server

SQLServerCentral » Latest topics
Need advice on how to process Access DBs with different table structures into SQL Server
I'm looking for some guidance on how to use SSIS to process Access database files into SQL Server.  I know how to process flat files thanks to a lot of good tutorials I've found but when it comes to Access DB files I've only seen cases where all the

Comic for 2018.03.03

RSSMix.com Mix ID 8239024
Comic for 2018.03.03
New Cyanide and Happiness Comic

query just runs; possible join issue?

SQLServerCentral » Latest topics
query just runs; possible join issue?
This report used to run until i added the CTE to pull MAX Created date from the Broker Feed table.
Now it just runs . . . Can anyone see an issue?  
thanks 


[code language="sql"

Saturday, March 3, 2018

How to bring database just before the delete occurred.

SQLServerCentral » Latest topics
How to bring database just before the delete occurred.

Good Morning Experts,

We are taking full backup every saturday at 9PM, differential backup daily at 9PM and transaction log backups every 30 minutes.

A developer accidentally deleted data from table at 2:4

Friday, March 2, 2018

how to let the recovery model set forever as simple

SQLServerCentral » Latest topics
how to let the recovery model set forever as simple
Dear Friends

my sql server is with recovery model set to simple, but every day it is changing to full.

how does it leave it forever as simple or how to create a job that changes it to simple?

Thanks
Almir

Introducing a DevOps culture

SQLServerCentral.com Articles
Introducing a DevOps culture

Your organization’s culture of DevOps will often be the defining factor on whether you have a successful organizational change, or whether the changes that you implement impact pockets of your organization.

Comic for 2018.03.02

RSSMix.com Mix ID 8239024
Comic for 2018.03.02
New Cyanide and Happiness Comic

Thursday, March 1, 2018

Using a view to implement SCD2 processing (preventing deadlocks)

SQLServerCentral » Latest topics
Using a view to implement SCD2 processing (preventing deadlocks)
Hi,

Question #1:

Scenario:
* I have a series of SCD2 source tables which are updated twice a week.
* I'm creating a downstream series of SCD2 target tables which are updated monthly.
* I am using a delta feed for the staging

Free eBook: SQL Server Transaction Log Management

SQLServerCentral.com Articles
Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.

Trying to get an SFTP process for SSIS

SQLServerCentral » Latest topics
Trying to get an SFTP process for SSIS
Hi,

 I have been looking all over the web for this. I realize that SSIS does not, on its own handle SFTP. A number of sites suggest using WinSCP, but have not gives a full explanation of how to code for this. Maybe its me but they seem to le