Rackspace, HPE expand on-premises cloud with pay-as-you-go Kubernetes

Network World Data Center

Rackspace, HPE expand on-premises cloud with pay-as-you-go Kubernetes

HPE and Rackspace are building on their alliance from last November, when they first introduced an OpenStack-based pay-per-use system designed to compete with public cloud providers.

The two now offer pay as you go to Rackspace’s VMware and Kubernetes private cloud services. Rackspace launched its Kubernetes private cloud managed service just last month. The initial pay-as-you-go system was for standard server-side apps. This new feature adds Kubernetes container management as an option.

Rackspace has deployed HPE’s new GreenLake Flex Capacity service to provide the pay-as-you-go pricing model. GreenLake is one of many programs by enterprise hardware vendors to provide on-demand pricing to companies looking to rein in data center costs.

To read this article in full, please click here

more info...

Azure DWH part 28: The ASDW enemies

SQLServerCentral.com Articles

Azure DWH part 28: The ASDW enemies

This time, we will talk about the competition or alternatives to Azure SQL Data Warehouse.

more info...

Comic for 2018.06.25

RSSMix.com Mix ID 8239024

Comic for 2018.06.25

New Cyanide and Happiness Comic

more info...

When it comes to salaries, I'm not average

SQLServerCentral » Latest topics

When it comes to salaries, I'm not average

Comments posted to this topic are about the item [B]When it comes to salaries, I'm not average[/B]

more info...

The silver lining in the Intel CEO drama

Network World Data Center

The silver lining in the Intel CEO drama

I assume that by now you’ve heard the news that Intel CEO Brian Krzanich has stepped down for reportedly violating the company's strict policy against having relationships with employees. As CFO Bob Swan takes the reigns, the question of who will replace Krzanich is front and center.

Several analysts I’ve spoken to even before this happened said they think Intel needs to look to the outside for its next CEO. In its 50-year history, the company has had only six CEOs, all of them insiders. Intel has a reputation as a tough place to work; nobody treads water at Intel. In the volatile Silicon Valley, I found Intel was a place where people either came and went fast or hung around forever. If you are cut out for its culture, expect to be promoted up the food chain rather quickly.

To read this article in full, please click here

more info...

Comic for 2018.06.24

RSSMix.com Mix ID 8239024

Comic for 2018.06.24

New Cyanide and Happiness Comic

more info...

IBM ends China's 5-year reign atop supercomputer rankings

Network World Data Center

IBM ends China's 5-year reign atop supercomputer rankings

There’s a shake-up – and a scandal – in the Top500 ranking of the world’s most powerful supercomputers.

The U.S. has retaken first place in the Top500 list after five years of dominance by China. Computers built by IBM for the U.S. Department of Energy have pushed the previous two record-holders, both Chinese, into second and fourth place.

[ Now see who's developing quantum computers.]

But the previous fourth placeholder, Japan’s Gyoukou, is nowhere to be found, after one of its creators was arrested on suspicion of fraud.

To read this article in full, please click here

more info...

Enable FIPS 140-2 Compliance in SQL Server

SQLServerCentral.com Articles

Enable FIPS 140-2 Compliance in SQL Server

What is FIPS? How do I use it? What is going to break if I do use it?

more info...

Repl-LogReader job blocking distribution cleanup job sql

SQLServerCentral » Latest topics

Repl-LogReader job blocking distribution cleanup job sql

Dear All,

The Repl-LogReader job is currently blocking distribution cleanup job sql; would there be a way of resolving the issue without restarting the service please?

more info...

Unable to start SQL Server service-error 3414

SQLServerCentral » Latest topics

Unable to start SQL Server service-error 3414

After the emergency shutdown of the computer the SQL Server (SQLEXPRESS) service does not start and gives an error message:

Failed to start SQL Server (SQLEXPRESS) on local computer. Details are contained in the system event log.... error code 34

more info...

Comic for 2018.06.23

RSSMix.com Mix ID 8239024

Comic for 2018.06.23

New Cyanide and Happiness Comic

more info...

Insert a duplicate copy of any record that meets certain criteria

SQLServerCentral » Latest topics

Insert a duplicate copy of any record that meets certain criteria

Sorry for this dumb question but I am very new to SQL. Could someone help me write a SQL code?

more info...

When it comes to salaries, I'm not average

SQLServerCentral » Latest topics

When it comes to salaries, I'm not average

Comments posted to this topic are about the item [B]When it comes to salaries, I'm not average[/B]

more info...

Comic for 2018.06.22

RSSMix.com Mix ID 8239024

Comic for 2018.06.22

New Cyanide and Happiness Comic

more info...

24 Hours of PASS (June 2018) - Recordings now available!

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

24 Hours of PASS (June 2018) - Recordings now available!

The sessions of the event 24 Hours of PASS Summit Preview edition (held this June on 12 and 13) were recorded and now they are available for streaming on-demand!

 

If you have missed one session or the entire event, you can view or review your preferred talk or topic. Each video is available on the detail page of the related session, sign in is mandatory. Aren't you a SQL PASS member, yet? Don't worry you can sign it up here for free!

A big "THANK YOU" to the Sponsors who made possible the organization of this event, free for participants!

Enjoy!

more info...

Plan now for your migration to Windows Server 2019

Network World Data Center

Plan now for your migration to Windows Server 2019

With the upcoming release of Windows Server 2019 this fall, it’s time for enterprise IT pros who work in Microsoft shops to start planning their migration to the new operating system.

As with any major release, it takes time to get familiar with what’s new and to start getting hands-on experience implementing new features. In this case, the enhancements include improved security and enhanced data-center capabilities.

[ Check out AI boosts data-center availability, efficiency. Also learn what hyperconvergence is and whether you’re ready for hyperconverged storage. | For regularly scheduled insights sign up for Network World newsletters. ]

So far among those who have been experimenting with the Insider Preview of Windows Server 2019 the most areas commonly deployed first are:

To read this article in full, please click here

more info...

Change Data Capture for a Specific User Only

SQLServerCentral » Latest topics

Change Data Capture for a Specific User Only

Morning Guys,

I wish to enable change data capture for a handful of tables, though I only want to audit/log when a specific user performs an update.

During general usage where this particular maintenance user is disabled I do not want to

more info...

SQL Server Restart or Cluster Failover Notification

SQLServerCentral.com Articles

SQL Server Restart or Cluster Failover Notification

How to create an automatic SQL restart or failover notification.

more info...

Converting Trace to Extended Events

SQLServerCentral.com Articles

Converting Trace to Extended Events

A walkthrough of a conversion of a SQL Trace setup to an Extended Event session.

more info...

Comic for 2018.06.20

RSSMix.com Mix ID 8239024

Comic for 2018.06.20

New Cyanide and Happiness Comic

more info...

Add missing data

SQLServerCentral » Latest topics

Add missing data

CREATE

more info...

Lenovo announces hybrid liquid-cooling system: Neptune

Network World Data Center

Lenovo announces hybrid liquid-cooling system: Neptune

Water cooling for enterprise servers is slowly creeping in from the fringes to the mainstream of data center use as vendors and end users alike realize the limitations of air cooling. With increased compute density, fans just don’t cut it anymore, and water cooling is far more efficient.

Several vendors have adapted their cabinets to accommodate water-cooling systems, and now Lenovo is the latest to get religion on the subject with Neptune, a series of technologies for the data center. The company announced the new system at the International Supercomputing Conference (ISC) in Frankfurt, Germany.

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

Neptune is a three-pronged approach, borrowed from the legend of the Roman god of the seas Neptune, who wields a three-pointed spear. It offers direct-to-node liquid cooling, rear door heat exchangers, and hybrid cooling that mixes air and liquid, all of which is documented in a lighthearted blog post by the company.

To read this article in full, please click here

more info...

Get first date and last date of the current month base on Work Week

SQLServerCentral » Latest topics

Get first date and last date of the current month base on Work Week

Hello all,

Thanks in advance for any assistance you can give me. 

What I am trying to get is the first date in the current month based off Monday to Sunday work week.   So for this month the first Date would be Monday 05/2

more info...

Comic for 2018.06.19

RSSMix.com Mix ID 8239024

Comic for 2018.06.19

New Cyanide and Happiness Comic

more info...

Stairway to ColumnStore Indexes Level 8: Optimizing Clustered Columnstore Indexes

SQLServerCentral.com Articles

Stairway to ColumnStore Indexes Level 8: Optimizing Clustered Columnstore Indexes

more info...

HPE places a $4B bet on its edge-network portfolio

Network World Data Center

HPE places a $4B bet on its edge-network portfolio

[ Check out our corporate guide to addressing IoT security. ]

HPE's pledge to pump billions of dollars into developing edge systems shines a light on the company's ambition to be the leading end-to-end computing infrastructure provider.

CEO Antonio Neri made the investment announcement at the company's Discover conference Tuesday in Las Vegas, in his first appearance at the company's annual event as chief executive. He took over the CEO role from Meg Whitman in February.

To read this article in full, please click here

more info...

Bureaucracy madness

SQLServerCentral » Latest topics

Bureaucracy madness

I spend only 20% of my time in management console. The rest 80% I spend in ITSM, creating change requests, with so many many fields that it takes minimum 20 mins to fill it correctly, and in Exchange, seeking for approvals.

Recently I spent appro

more info...

Comic for 2018.06.18

RSSMix.com Mix ID 8239024

Comic for 2018.06.18

New Cyanide and Happiness Comic

more info...

SQL Server Database Corruption Detection

SQLServerCentral.com Articles

SQL Server Database Corruption Detection

How to detect DB corruption ASAP...

more info...

Cisco’s David Goeckeler talks security, networking, software and SD-WAN outlook

Network World Data Center

Cisco’s David Goeckeler talks security, networking, software and SD-WAN outlook

David Goeckeler doesn’t wear all of the hats at Cisco but he certainly wears one of the biggest.

Responsible for 20,000 engineers and $32 billion worth of the networking giant’s business, Goeckeler, executive vice president and general manager, masterminds Cisco's network and security strategy which now features ever more emphasis on software. In fact, at the recent Cisco Live, Goeckeler emphasized that notion saying, “all the routers and switches and wireless access points (and in big networks there are going to be tens of thousands of those in a single enterprise network) we're thinking about that as one large software system.”

To read this article in full, please click here

more info...

State v Migrations

SQLServerCentral » Latest topics

State v Migrations

Comments posted to this topic are about the item [B]State v Migrations[/B]

more info...

SQL Server Database Corruption Detect

SQLServerCentral.com Articles

SQL Server Database Corruption Detect

How to detect DB corruption ASAP...

more info...

Cisco makes SD-WAN integration a top priority

Network World Data Center

Cisco makes SD-WAN integration a top priority

Software and programmable intelligent networks were hot topics at Cisco Live last week, and one of the key components of that discussion was the direction of the company’s SD-WAN strategy.

Central to that dialog is how Cisco plans to use and integrate the SD-WAN technology it acquired last year when it bought Viptela for $610 million. For the moment, Cisco says Viptela has brought with it interest to the tune of about 800 new customers in recent months.

To read this article in full, please click here

more info...

Comic for 2018.06.17

RSSMix.com Mix ID 8239024

Comic for 2018.06.17

New Cyanide and Happiness Comic

more info...

Jobs You Wouldn't Expect To Be Threatened By Tech But Are

SQLServerCentral.com Articles

Jobs You Wouldn't Expect To Be Threatened By Tech But Are

Will there be a fair balance between the coming generations of technology and the human workforce? Here is a list of industries that may not think yes.

more info...

Jobs You Wouldn't Expect To Be Threatened By Tech But Are

SQLServerCentral » Latest topics

Jobs You Wouldn't Expect To Be Threatened By Tech But Are

Comments posted to this topic are about the item [B]Jobs You Wouldn't Expect To Be Threatened By Tech But Are[/B]

more info...

Comic for 2018.06.16

RSSMix.com Mix ID 8239024

Comic for 2018.06.16

New Cyanide and Happiness Comic

more info...

Errodumps consuming space

SQLServerCentral » Latest topics

Errodumps consuming space

Hi Experts,
We are facing space issue due to Errordumps getting created in the following folder:
C:\Program Files\Microsoft SQL Server\110\Shared\ErrorDumps
After a bit of googling came to know these are because of generating dump files for pa

more info...

Comic for 2018.06.15

RSSMix.com Mix ID 8239024

Comic for 2018.06.15

New Cyanide and Happiness Comic

more info...

SSRS 2016 - HTML5 rendering issues

SQLServerCentral » Latest topics

SSRS 2016 - HTML5 rendering issues

Hello,

We migrate reports from a SSRS2012 Instance with Sharepoint integration to a SSRS2016 Instance in native mode and we encounter some issues with one report.
The first issue is the time to show the report, on sharepoint SSRS2012 environm

more info...

Building Test Data

SQLServerCentral » Latest topics

Building Test Data

Comments posted to this topic are about the item [B]Building Test Data[/B]

more info...

Select from table with to colums in to different levels

SQLServerCentral » Latest topics

Select from table with to colums in to different levels

Hello, I have a SQL table with two columns that contain numbers. The first column is the upper level an the second the under level. The problem is that the under level is also again in the first column and it has his own under levels. So the first under

more info...

Splitting Strings in SQL Server 2016

SQLServerCentral.com Articles

Splitting Strings in SQL Server 2016

Comparison of the new methods of splitting strings in SQL Server 2016 to the tried and true methods

more info...

Facebook releases its load balancer as open-source code

Network World Data Center

Facebook releases its load balancer as open-source code

Google is known to fiercely guard its data center secrets, but not Facebook. The social media giant has released two significant tools it uses internally to operate its massive social network as open-source code.

The company has released Katran, the load balancer that keeps the company data centers from overloading, as open source under the GNU General Public License v2.0 and available from GitHub. In addition to Katran, the company is offering details on its Zero Touch Provisioning tool, which it uses to help engineers automate much of the work required to build its backbone networks.

To read this article in full, please click here

more info...

Comic for 2018.06.13

RSSMix.com Mix ID 8239024

Comic for 2018.06.13

New Cyanide and Happiness Comic

more info...

SQL Server From .Net: Reading SQL Server Metadata in ADO.Net

SQLServerCentral.com Articles

SQL Server From .Net: Reading SQL Server Metadata in ADO.Net

A basic introduction for developers (or anyone) about reading the metadata of a SQL Server database from a .Net application.

more info...

Friday Fun - Excel Formula to SQL Functions

SQLServerCentral » Latest topics

Friday Fun - Excel Formula to SQL Functions

I recently found a nifty Excel Formula that worked out if a datetime was UTC or BST (British Summer time) and adjusted the input accordingly to output UTC
Here's the formula, where C3 contains the date to convert (or leave alone if already UTC, i.e. n

more info...

Rackspace introduces data center colocation services

Network World Data Center

Rackspace introduces data center colocation services

The effort around data center reduction has been to draw down everything, from hardware to facilities. Rackspace has an interesting new twist, though: Put your hardware in our data centers.

The company announced a new data center colocation business this week, offering space, power, and network connectivity to customers who provide their own hardware. The facilities are in 10 locations around the world.

It’s not a bad idea. The servers are the cheapest expense compared to facility costs, such as the physical building, power, and cooling.

[ Learn how server disaggregation can boost data center efficiency and how Windows Server 2019 embraces hyperconverged data centers. | Get regularly scheduled insights by signing up for Network World newsletters. ] 'Lift and shift' to the cloud

The new business, dubbed Rackspace Colocation, is positioned as a way for enterprises to kick off their cloud journey by getting out of their self-managed data center to lower their expenses as they move to the cloud.

To read this article in full, please click here

more info...

Comic for 2018.06.12

RSSMix.com Mix ID 8239024

Comic for 2018.06.12

New Cyanide and Happiness Comic

more info...

SSRS 2016 - HTML5 rendering issues

SQLServerCentral » Latest topics

SSRS 2016 - HTML5 rendering issues

Hello,

We migrate reports from a SSRS2012 Instance with Sharepoint integration to a SSRS2016 Instance in native mode and we encounter some issues with one report.
The first issue is the time to show the report, on sharepoint SSRS2012 environm

more info...

The SQL Saturday Thread

SQLServerCentral » Latest topics

The SQL Saturday Thread

As popular as SQL Saturday is, I'm surprised that nobody created a thread dedicated to SQL Saturday, so I created this one. Let's see how much traffic this gets! Who's coming out to Albany, NY for [url=http://www.sqlsaturday.com/513/eventhome.aspx]SQL

more info...

Stairway to Azure SQL Database: Level 1 Getting Started

SQLServerCentral.com Articles

Stairway to Azure SQL Database: Level 1 Getting Started

In this first level, learn how to get started with Azure and Azure SQL Database.

more info...

Cisco developer push yields 500,000 DevNet members working on programmable networks

Network World Data Center

Cisco developer push yields 500,000 DevNet members working on programmable networks

ORLANDO – Cisco’s developer program, DevNet, is on a hot streak.

Speaking at Cisco Live 2018, DevNet CTO Susie Wee said the group, which was founded in 2014, now has 500,000 registered members.

"That’s a pretty cool milestone, but what does it mean? It means that we've hit critical mass with a developer community who can program the network," Wee said. "Our 500,000 strong community is writing code that can be leveraged and shared by others. DevNet is creating a network innovation ecosystem that will be the hub of the next generation of applications and the next generation of business."

At Cisco Live the company also announced it has expanded the DevNet world to include:

To read this article in full, please click here

more info...

Query that returns winnings for a year and zero if no winnings for year

SQLServerCentral » Latest topics

Query that returns winnings for a year and zero if no winnings for year

[code language="sql"]
create table #Achievements (Ach_ID INT, Description varchar (30), Bonus_Points int)
create table #PlayersAchievments (Player_ID INT, Ach_ID INT, Winning_Date DATE)

INSERT INTO

more info...

Dynamic File Column mapping in SSIS.

SQLServerCentral.com Articles

Dynamic File Column mapping in SSIS.

An efficient and reliable method for reading CSV files with variable columns.

more info...

Comic for 2018.06.11

RSSMix.com Mix ID 8239024

Comic for 2018.06.11

New Cyanide and Happiness Comic

more info...

IBM launches new availability zones worldwide for hybrid enterprise clouds

Network World Data Center

IBM launches new availability zones worldwide for hybrid enterprise clouds

CIOs and data center managers who run large hybrid clouds worldwide have a good chance of hearing IBM knock on their doors in the next few months.

That's because IBM is opening 18 new "availability zones" for its public cloud across the U.S., Europe, and Asia-Pacific. An availability zone is an isolated physical location within a cloud data center that has its own separate power, cooling and networking to maximize fault tolerance, according to IBM.

Along with uptime service level agreements and high-speed network connectivity, users have gotten used to accessing corporate databases wherever they reside, but proximity to cloud data centers is important. Distance to data centers can have an impact on network performance, resulting in slow uploads or downloads.

To read this article in full, please click here

more info...

Comic for 2018.06.10

RSSMix.com Mix ID 8239024

Comic for 2018.06.10

New Cyanide and Happiness Comic

more info...

Improving SQL Server 2016 Large Database Performance

SQLServerCentral.com Articles

Improving SQL Server 2016 Large Database Performance

This article aims to save you days or weeks of troubleshooting when using SQL Server 2016 for large databases

more info...

T-SQL help needed to eliminate duplicates from table

SQLServerCentral » Latest topics

T-SQL help needed to eliminate duplicates from table

To make a long story short, one of our tables that have rx data has got messed up because the files get loaded more than one and as a result we now have duplicate records. Your help is needed to clean this up.

more info...

Get Index Fragmentation Cheaply

SQLServerCentral » Latest topics

Get Index Fragmentation Cheaply

Is there a cheaper way to write this (from a query cost perspective)?  It seems to churn quite a bit of DTU's on our Azure DB's and ends up on our Top Resource Consuming queries in Query Store.

SELECT '' AS 'Database',
   

more info...

The BAG Secondary

SQLServerCentral » Latest topics

The BAG Secondary

Comments posted to this topic are about the item [B]The BAG Secondary[/B]

more info...

Comic for 2018.06.09

RSSMix.com Mix ID 8239024

Comic for 2018.06.09

New Cyanide and Happiness Comic

more info...

美国毕业证文凭 马里兰大学帕克分校毕业证UMD毕业证Q/微501479313马里兰大学帕克分校成绩单UMD成绩单马里兰大学帕克分校学历证书UMD学历证书马里兰大学帕克分校假文凭UMD+马里兰大学帕克分校学历认证UMD学历认证

SQLServerCentral » Latest topics

美国毕业证文凭 马里兰大学帕克分校毕业证UMD毕业证Q/微501479313马里兰大学帕克分校成绩单UMD成绩单马里兰大学帕克分校学历证书UMD学历证书马里兰大学帕克分校假文凭UMD+马里兰大学帕克分校学历认证UMD学历认证

QQ微信:501479313代办国外毕业证、代办澳洲毕业证、代办美国毕业证、代办加拿大毕业证、代办英国毕业证、代办国外毕业证、代办德国毕业证、代办英国毕业证、代办法国毕业证、代办德国毕业证、办理国外毕业证、办理澳洲毕业证、办理美国毕业证、办理加拿大毕业证、办理英国毕业证、办理德国毕业证、购买国外毕业证、购买澳洲毕业证、购买美国毕业证、购买加拿大毕业证、购买英国毕业证、购买德国毕业证、办理国外毕业证、办理澳洲毕业证、办理美国毕业证、办理加拿大毕业证、办理英国毕业证、办理德国毕业证、购买国外毕业证、购买澳洲毕

more info...

Summit: How IBM and Oak Ridge laboratory are changing supercomputing

Network World Data Center

Summit: How IBM and Oak Ridge laboratory are changing supercomputing

The team designing Oak Ridge National Laboratory's new Summit supercomputer correctly predicted the rise of data-centric computing – but its builders couldn't forecast how bad weather would disrupt the delivery of key components.

Nevertheless, almost four years after IBM won the contract to build it, Summit is up and running on schedule. Jack Wells, Director of Science for Oak Ridge Leadership Computing Facility (OLCF), expects the 200-petaflop machine to be fully operational by early next year.

[ Now see who's developing quantum computers.]

"It's the world's most powerful and largest supercomputer for science," he said.

To read this article in full, please click here

more info...

Better Comments

SQLServerCentral » Latest topics

Better Comments

Comments posted to this topic are about the item [B]Better Comments[/B]

more info...

I thought my database was collation agnostic

SQLServerCentral.com Articles

I thought my database was collation agnostic

My struggles with a customer's database that used a different collation sequence. The easy way is never the right way, or is it?

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.

more info...

Network-intelligence platforms, cloud fuel a run on faster Ethernet

Network World Data Center

Network-intelligence platforms, cloud fuel a run on faster Ethernet

2018 is shaping up to be a banner year for all things Ethernet.

First of all, the ubiquitous networking technology is having a banner year already in the data center where in the first quarter alone, the switching market recorded its strongest year-over-year revenue growth in over five years, and 100G Ethernet port shipments more than doubled year-over-year, according to a report by Dell’Oro Group researchers.

[ Now see who's developing quantum computers.]

The 16-percent switching growth was, "driven by the large-tier cloud hyperscalers such as Amazon, Google, Microsoft and Facebook but also by enterprise customers,” said Sameh Boujelbene, senior director at Dell’Oro.

To read this article in full, please click here

more info...

Docker SQL Server 2017 Linux Containers with database cloning

SQLServerCentral.com Articles

Docker SQL Server 2017 Linux Containers with database cloning

Learn how containers can help with database development.

more info...

How to spread an invoice tax across invoice lines without loosing rounded remainder in a view?

SQLServerCentral » Latest topics

How to spread an invoice tax across invoice lines without loosing rounded remainder in a view?

I have a view, which shows Invoice Details table. This view is used to print invoices to the customers.
In my case each record of Invoice Details is a passenger, so for three passengers, as in my example below, I will have three Invoice Details recor

more info...

Intel launches Optane, the go-between for memory and storage

Network World Data Center

Intel launches Optane, the go-between for memory and storage

Intel formally introduced the Optane DC persistent memory modules late last week, an entirely new class of memory and storage technology designed to sit between storage and memory and provide expanded memory capacity and faster access to data.

Unlike SSDs, which plug into a PCI Express slot, Optane DC is built like a thick memory DIMM and plugs into the DIMM slots. Many server motherboards offer as many as eight DIMM slots per CPU, so some can be allocated to Optane and some to traditional memory.

That’s important because Optane serves as a cache of sorts, storing frequently accessed data in its memory rather than forcing the server to fetch it from a hard disk. So, server memory only has to access Optane memory, which is sitting right next to it, and not a storage array over Fibre Channel.

To read this article in full, please click here

more info...

Installing sql 2005 using "disk1" and "disk 2"

SQLServerCentral » Latest topics

Installing sql 2005 using "disk1" and "disk 2"

Someone copied the contents of the sql 2005 cd's into folders caled "disk 1" and "disk 2" on a server.  On that server I can open "disk 1"and double-click setup.exe to get the ball rolling. But I'm concerned that the install process may require&nb

more info...

Comic for 2018.06.06

RSSMix.com Mix ID 8239024

Comic for 2018.06.06

New Cyanide and Happiness Comic

more info...

My last blogpost, here

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

My last blogpost, here

I've been in the process of moving my blog for some time now. One thing lead to the other, among them changing my web-site from Window-based to Linux-based. But, that is behind me, and I have now moved my blog-posts. I am very grateful to Adam and Peter for allowing me to have my blog here at sqlblog. And it has been humbling to be in such great company. Thanks a lot to Adam for the help in moving my old blog posts! Times are changing, and I now have a more modern platform for my blog. From now on,...(read more)

more info...

IBM strengthens mainframe cloud services with CA’s help

Network World Data Center

IBM strengthens mainframe cloud services with CA’s help

IBM continues to mold the Big Iron into a cloud and devops beast.

This week IBM and its long-time ally CA teamed up to link the mainframe and its Cloud Managed Services on z Systems, or zCloud, software with cloud workload-development tools from CA with the goal of better performing applications for private, hybrid or multicloud operations.

[ For more on mainframes, read: The (mostly) cool history of the IBM mainframe and Why are mainframes still in the enterprise data center? | Get regularly scheduled insights by signing up for Network World newsletters. ]

IBM says zCloud offers customers a way to move critical workloads into a cloud environment with the flexibility and security of the mainframe. In addition, the company offers the IBM Services Platform with Watson that provides another level of automation within zCloud to assist clients with their moves to cloud environments.

To read this article in full, please click here

more info...

Stairway to ColumnStore Indexes Level 7: Optimizing Nonclustered Columnstore Indexes

SQLServerCentral.com Articles

Stairway to ColumnStore Indexes Level 7: Optimizing Nonclustered Columnstore Indexes

In this level, we will focus on optimization techniques to apply while building the nonclustered columnstore index, which is available in all versions of SQL Server from 2012 up.

more info...

Playing a sound from an SSRS Report

SQLServerCentral » Latest topics

Playing a sound from an SSRS Report

I have been tasked with trying to get a dashboard style SSRS report to play a sound.

We have a report that is displayed on a large screen on our sales floor. It auto refreshes every 2 minutes. On there is a section for new deals that have been do

more info...

Your hardware order is ready. Do you want cables with that?

Network World Data Center

Your hardware order is ready. Do you want cables with that?

In a previous blog post, 5 reasons to buy refurbished Cisco equipment, I talked about five facts to keep in mind as you consider how to proceed with your Cisco hardware solutions.

Well, my engineering group reminded me of something else to consider for any hardware solution, not just a Cisco solution.

Cabling!

[ Read also: Getting grounded in intent-based networking ]

It seems that cabling can be an afterthought. Sure, you just used a blended solution of new and pre-owned hardware, where each makes the most sense in your infrastructure and creates a unique and potentially game-changing opportunity to maximize value in your investments.

To read this article in full, please click here

more info...

FK Limits

SQLServerCentral » Latest topics

FK Limits

Comments posted to this topic are about the item [B]FK Limits[/B]

more info...

Logshipping to SQL Server on Linux

SQLServerCentral.com Articles

Logshipping to SQL Server on Linux

An example of a database migration from SQL Server 2016 on Windows to MS SQL Server 2017 on Linux.

more info...

Comic for 2018.06.05

RSSMix.com Mix ID 8239024

Comic for 2018.06.05

New Cyanide and Happiness Comic

more info...

Scalar Functions with Query Plans: Not all is obvious!

SQLServerCentral.com Articles

Scalar Functions with Query Plans: Not all is obvious!

Scalar functions in Query Plans just don't always show the whole story!

more info...

Availability Group - Log Redo? What does that mean exactly?

SQLServerCentral » Latest topics

Availability Group - Log Redo? What does that mean exactly?

I am trying to better understand this
SQL Server 2016/2017: Availability group secondary replica redo model and performance – MSSQL Tiger Team

more info...

24 Hours of PASS (June 2018) - Summit Preview

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

24 Hours of PASS (June 2018) - Summit Preview

Which topics can you expect to see at the PASS Summit 2018? Find it out from June 12 to 13, 2018 at the 24 Hours of PASS - Summit 2018 Preview - edition.

Register now at this link, thanks to the Sponsors, the 24 Hours of PASS is presented at no cost for you!

This edition of 24 Hours of PASS wants to be a sneak taste of what you can expect from the next PASS Summit that will be in Seattle (WA) from November 6th to 9th, 2018.

No matter from what part of the world you will follow the event, the important thing is to know that they will be 24 hours of continuous training on Microsoft Data Platform (Performance Tuning, Azure Data Lake, Digital Storytelling, Advanced R, Power BI and more!), direct on your desk!

Enjoy!

more info...

Comic for 2018.06.03

RSSMix.com Mix ID 8239024

Comic for 2018.06.03

New Cyanide and Happiness Comic

more info...

办温切斯特大学毕业证成绩单Q薇1010636782(Winchester)温切斯特大学毕业证办理“成绩单办理，文凭制作”英国学历办理University of Winchester

SQLServerCentral » Latest topics

办温切斯特大学毕业证成绩单Q薇1010636782(Winchester)温切斯特大学毕业证办理“成绩单办理，文凭制作”英国学历办理University of Winchester

【Q/薇1010636782】专业办理学历认证&鸿途教育告诉您学历认证要趁早办理哦，一次办理，终生有效，快速专业，诚信可靠。本公司专业面向“英国、加拿大、意大利，澳洲、新西兰、美国 ”等国的学历学位真实教育部认证、使馆认证。
 主营项目：
★办理真实使馆公证（即留学回国人员证明，免费申请免税车，不成功不收费！！！）
★办理教育部国外学历学位认证。（国家留服网上可查、永久存档；快速稳妥，回国发展，考公务员，落户，进国企，外企，创业--无忧愁）
★办理各国各大

more info...

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!

more info...

Same query, two users, different performance

SQLServerCentral » Latest topics

Same query, two users, different performance

Hey Gurus, I have a query that performs differently depending upon the user executing it. This was first brought to my attention because an Excel spreadsheet was taking a long time to load data (Excel 2010, Sql Server 2008 R2). The query was awful, I r

more info...

Comic for 2018.06.02

RSSMix.com Mix ID 8239024

Comic for 2018.06.02

New Cyanide and Happiness Comic

more info...

Suddenly the server market is hot again

Network World Data Center

Suddenly the server market is hot again

After years of shrinking sales, the server market is suddenly hot, very hot. According to the latest figures from IDC, worldwide server shipments increased 20.7% year over year to 2.7 million units in Q1 of 2018, and revenue rose 38.6%.

This is the third consecutive quarter of double-digit growth, and it’s being driven by a number of factors. They include a marketwide enterprise refresh cycle, strong demand from cloud service providers, increased use of servers as the core building blocks for software-defined infrastructure, broad demand for newer CPUs, and growing deployments of next-generation workloads.

Average selling prices (ASP) increased during the quarter due to richer configurations and increased component costs. The increased ASPs also contributed to revenue growth. Volume server revenue grew by 40.9%, to $15.9 billion, while midrange server revenue grew 34%, to $1.7 billion, and high-end systems grew 20.1%, to $1.2 billion.

To read this article in full, please click here

more info...

How to get Last Occurance of % value in the string...

SQLServerCentral » Latest topics

How to get Last Occurance of % value in the string...

Hello Good Morning

How to get Last Occurance of % value in the string... please help me with this situation


[code language="sql"]

more info...

NonClustered Index Structure

SQLServerCentral.com Articles

NonClustered Index Structure

Learn how the clustered index keys affect the non clustered index structure.

more info...

Comic for 2018.06.01

RSSMix.com Mix ID 8239024

Comic for 2018.06.01

New Cyanide and Happiness Comic

more info...