SQL Joker - blog

Monday, April 30, 2018

Rackspace offers on-premises 'cloud' and a bare-metal cloud offering

Network World Data Center

Rackspace offers on-premises 'cloud' and a bare-metal cloud offering

Rackspace offers on-premises 'cloud' and a bare-metal cloud offering

Rackspace’s latest project is called Private Cloud Everywhere and is a collaboration with VMware to offer what it calls Private Cloud as a Service (PCaaS), making on-demand provisioning of virtualized servers available at most colocation facilities and data centers.

PCaaS basically means provisioning data center hardware the same way you would on Amazon Web Services, Microsoft Azure or Google Cloud, but instead of using the cloud providers, you use your own hardware, use Rackspace data centers, or set it up in a third-party colocation facility.

[ Check out What is hybrid cloud computing and learn what you need to know about multi-cloud. | Get regularly scheduled insights by signing up for Network World newsletters. ]

To read this article in full, please click here

24 Hours of PASS (April 2018): Recordings now available!

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

24 Hours of PASS (April 2018): Recordings now available!

The Sessions of the event 24 Hours of PASS "Cross-Platform SQL Server Management" edition (held this April on 25 and 26) 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 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 (Microsoft, Quest, IDERA, SentryOne e Redgate) who made possible the organization of this event, free for participants!

Enjoy!

Comic for 2018.04.30

RSSMix.com Mix ID 8239024

Comic for 2018.04.30

New Cyanide and Happiness Comic

Strange "The datepart millisecond is not supported by date function dateadd for data type date." error

SQLServerCentral » Latest topics

Strange "The datepart millisecond is not supported by date function dateadd for data type date." error

Hi,

I am getting strange error 9810 "The datepart millisecond is not supported by date function dateadd for data type d

Self SQL Injection

SQLServerCentral.com Articles

Self SQL Injection

Based on a real fact, this article demonstrates how a bad use of sp_executesql can lead to unpleasant surprises

Sunday, April 29, 2018

Comic for 2018.04.29

RSSMix.com Mix ID 8239024

Comic for 2018.04.29

New Cyanide and Happiness Comic

Identifying list of users or groups that have create table permission

SQLServerCentral » Latest topics

Identifying list of users or groups that have create table permission

Experts,

Do you'll know of a way to get details on how to get the list of users/groups (we have lot of group accounts) that have create table permission or is part of db_ddlamin group or db_owner or sysadmin etc. I would like to get these details

Microsoft hiring globally for Cosmos DB product team

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

Microsoft hiring globally for Cosmos DB product team

https://www.joincosmosdb.com/...(read more)

Deleting AG. Some questions

SQLServerCentral » Latest topics

Deleting AG. Some questions

Good Morning Experts,

If i delete the Availability Group(AG) in primary replica, what will be the status of databases in primary replica and secondary replica? What will be the status of AG on secondary replica?

Saturday, April 28, 2018

SQL Server 2016 Service Pack 2 (SP2) has been released!

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

SQL Server 2016 Service Pack 2 (SP2) has been released!

The Service Pack 2 of SQL Server 2016 has been released!

From the SQL Server Release Services, this service pack contains:

Performance and scale improvementsSupportability and diagnostics enhancementsNew improvements based on Connect feedback itemsSome improvements originally introduced in SQL Server 2014 SP2 and SQL Server 2012 SP4All the fixes up to SQL Server 2016 SP1 CU8

All the details are listed in this article.

You can download the SP2 of SQL Server 2016 here:

SQL Server 2016 SP2 SQL Server 2016 SP2 Express SQL Server 2016 SP2 Feature Pack SQL Server 2016 SP2 Release Information

The Service Pack 2 installation is recommended, but installing this service pack may require rebooting the instance!

Comic for 2018.04.28

RSSMix.com Mix ID 8239024

Comic for 2018.04.28

New Cyanide and Happiness Comic

CDC Enabled database Capture Job failing

SQLServerCentral » Latest topics

CDC Enabled database Capture Job failing

Hi.

I am getting the following errors in my CDC Capture job that is failing.

The Log-Scan Process failed to construct a replicated command from log sequence number (LSN) {00000783:0020e794:0052}. Back up the publication database an

Friday, April 27, 2018

Cosmos DB Documentation Updated

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

Cosmos DB Documentation Updated

Microsoft has greatly improved the Cosmos DB documentation making it much easier to learn and get started. Check it out at https://docs.microsoft.com/en-us/azure/cosmos-db/...(read more)

Combining address fields into 1 address field - bullet proof method.

SQLServerCentral » Latest topics

Combining address fields into 1 address field - bullet proof method.

I often have to combine multiple address fields into 1 for a variety of reasons. I can hack a calculation that works for each case. But I'm trying to learn the optimal method and possibly develop

Comic for 2018.04.27

RSSMix.com Mix ID 8239024

Comic for 2018.04.27

New Cyanide and Happiness Comic

Subscribe to: Posts (Atom)