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’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

more info...

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!

more info...

Comic for 2018.04.30

RSSMix.com Mix ID 8239024

Comic for 2018.04.30

New Cyanide and Happiness Comic

more info...

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

more info...

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

more info...

Comic for 2018.04.29

RSSMix.com Mix ID 8239024

Comic for 2018.04.29

New Cyanide and Happiness Comic

more info...

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

more info...

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)

more info...

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?

more info...

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 SP2SQL Server 2016 SP2 ExpressSQL Server 2016 SP2 Feature PackSQL Server 2016 SP2 Release Information

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

more info...

Comic for 2018.04.28

RSSMix.com Mix ID 8239024

Comic for 2018.04.28

New Cyanide and Happiness Comic

more info...

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

more info...

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)

more info...

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

more info...

Comic for 2018.04.27

RSSMix.com Mix ID 8239024

Comic for 2018.04.27

New Cyanide and Happiness Comic

more info...

Powershell To Get Active Directory Users And Groups into SQL

SQLServerCentral.com Articles

Powershell To Get Active Directory Users And Groups into SQL

Use Powershell to query AD for Users, Groups and GroupMembers

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...

IDG Contributor Network: How to achieve and sustain peak performance in your data center

Network World Data Center

IDG Contributor Network: How to achieve and sustain peak performance in your data center

As Tom Brady once said, “if you don’t play to win, don’t play at all.” This mantra is reflected in Brady’s TB12 Method, a holistic lifecycle based on 12 principles that make up the optimal approach to exercise, training and living a life of vitality. It’s built on the premise of stopping an accident prior to it happening through pre-habitation and taking intelligent, strategic preventative measures. And while implementing all 12 principles is not required, their effect is cumulative: the more you can incorporate, the better your results will be.

While this methodology applies to training superior athletes, data center managers have their own set of principles to ensure optimal data center performance. What we’ve dubbed the DCM10 Method, there are 10 fundamental steps every data center manager should use to evaluate their current data center and help transform its functionality. Similar to the TB12 Method, while not all of these steps are required to create a successful strategy, the more best practices applied will result in higher performance across the board.

To read this article in full, please click here

more info...

Filtering a CAST

SQLServerCentral » Latest topics

Filtering a CAST

Comments posted to this topic are about the item [B]Filtering a CAST[/B]

more info...

Google's Partner Interconnect connects SMBs to its data centers

Network World Data Center

Google's Partner Interconnect connects SMBs to its data centers

If you are a large-scale enterprise, Google has a service called Dedicated Interconnect that offers 10Gbps connections between your data center and one of theirs. But what if you are a smaller firm and don’t need that kind of bandwidth and the expense that goes with it?

Google now has you covered. The cloud giant recently announced Google Cloud Partner Interconnect, a means of establishing a direct connection between a SMB data center, with emphasis on the medium-sized business, and Google's hybrid cloud platform. The company did this in concert with 23 ISP partners around the globe.

To read this article in full, please click here

more info...

Recovery mode reverting to Full

SQLServerCentral » Latest topics

Recovery mode reverting to Full

Perhaps I am missing something 'Simple'...

 I am running an instance on AWS RDS..

I am trying to set the recovery mode of a database to simple eg:
ALTER DATABASE [Test] SET RECOVERY SIMPLE

his works fine, and I can see

more info...

Missing Index Impact and Join Type

SQLServerCentral.com Articles

Missing Index Impact and Join Type

Erik Darling shows how missing index requests have different impact numbers depending on the query's join type.

more info...

Comic for 2018.04.25

RSSMix.com Mix ID 8239024

Comic for 2018.04.25

New Cyanide and Happiness Comic

more info...

Cyxtera offers on-demand data center provisioning software

Network World Data Center

Cyxtera offers on-demand data center provisioning software

Cyxtera Technologies has launched the Cyxtera Extensible Data Center (CXD) platform, a software platform for data centers that offers customers rapid on-demand provisioning to a host of colocation and connectivity services.

Through a combination of a network and services provisioning engine and an intra-data center software-defined network fabric, the CXD platform allows colocation customers to provision services on demand or via a web console.

CXD brings cloud-like experience to colocation

CXD comes with two key features: the Unified Services Port and Network Exchange. The Unified Services Port enables access to multiple data center services over a single physical port, while the Network Exchange provides automated provisioning to select network service providers. The caveat is they must also be running CXD.

To read this article in full, please click here

more info...

Comic for 2018.04.24

RSSMix.com Mix ID 8239024

Comic for 2018.04.24

New Cyanide and Happiness Comic

more info...

Stairway to SQL PowerShell Level 10: Getting data in and out of SQL Server using SQL Server PowerShell

SQLServerCentral.com Articles

Stairway to SQL PowerShell Level 10: Getting data in and out of SQL Server using SQL Server PowerShell

In this level we will look at ways of getting data into and out of SQL Server. We will specifically look at the Database object and a cmdlet Invoke-Sqlcmd or Invoke-SqlCmd2. To get data in, we are going to leverage a PowerShell script that uses SMO to put data into a predefined table in SQL Server.

more info...

Text data type

SQLServerCentral » Latest topics

Text data type

Is it still supported by SS 2016?
Thanks

more info...

Packaged-Application Database Nightmares - A Horror Story

SQLServerCentral.com Articles

Packaged-Application Database Nightmares - A Horror Story

The business decides on a packaged application and buys it. After installation, you look at the schema and realize that is is a nightmare. How do you manage this nightmare?

more info...

Select statement based on getdate() depending on time of day

SQLServerCentral » Latest topics

Select statement based on getdate() depending on time of day

I have a need for a select statement which uses current date/time and if hour is less than 15(3PM) the starting date is set for one day less. Here is my code, but as I understand it, it's T-SQL and it doesn't play nice when i'm trying to build my view.&nb

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...

Comic for 2018.04.23

RSSMix.com Mix ID 8239024

Comic for 2018.04.23

New Cyanide and Happiness Comic

more info...

Cancelling DBCC SHRINKFILE with EMPTYFILE

SQLServerCentral.com Articles

Cancelling DBCC SHRINKFILE with EMPTYFILE

A fun experiment using DBCC SHRINKFILE to rebalance data.

more info...

Subquery as column

SQLServerCentral » Latest topics

Subquery as column

Is this
select (select top 1 organisation from sysfile) as org,* from area1
More efficient than a join ?
i.e. will it do the subquery to get the 

more info...

Comic for 2018.04.22

RSSMix.com Mix ID 8239024

Comic for 2018.04.22

New Cyanide and Happiness Comic

more info...

SSIS package x SQL Server Agent error

SQLServerCentral » Latest topics

SSIS package x SQL Server Agent error

Hello!

I'm experiencing a SSIS package error during execution. The package runs ok without error and runs the proccess below:
1. Create a Excel file;
2. Input data into Excel file;
3. Format sheets with bold, fonts, colors and more...

more info...

YTD Calculation

SQLServerCentral » Latest topics

YTD Calculation

hi ,
i  need help with calculating YTD for Tax and TaxablePay. I already have a script that calculates the monthly values but i just cant get the YTD totals right. Any help will be highly appreciated.

IF OBJECT_ID ( 'spTaxReturn', 'P' )

more info...

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

more info...

Comic for 2018.04.20

RSSMix.com Mix ID 8239024

Comic for 2018.04.20

New Cyanide and Happiness Comic

more info...

Transferring data between tables

SQLServerCentral » Latest topics

Transferring data between tables

Hi all

I've got a real brain-buster on my hands.....
First, some background.
We do an incremental load of various tables from a 3rd-party database that uses electronic documents and stores the data all over the place.
We put all the d

more info...

Making Deployments Simpler with Re-runnable Scripts

SQLServerCentral.com Articles

Making Deployments Simpler with Re-runnable Scripts

Make sure your SQL Server database release scripts to make life easier.

more info...

Is Facebook looking to build its own data center chips?

Network World Data Center

Is Facebook looking to build its own data center chips?

A job posting on Facebook has led to speculation that the company is building a team to design its own semiconductors, thus ending their reliance on Intel. If so, it would be another step in the trend of major firms building their own silicon.

Bloomberg was the first to note a job opening, titled “Manager, ASIC Development,” that sought a manager to help build an "end-to-end SoC/ASIC, firmware and driver development organization." There is also an opening for an “ASIC & FPGA Design Engineer,” which seems an unusual position for a social network website to need.

To read this article in full, please click here

more info...

Comic for 2018.04.18

RSSMix.com Mix ID 8239024

Comic for 2018.04.18

New Cyanide and Happiness Comic

more info...

Do you check your backups?

SQLServerCentral.com Articles

Do you check your backups?

Backups. Are you confident you can restore? Do you have a process that ensures you can recover your systems? Learn how one system works in the cloud.

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...

How to check sql 2000 compatibility on sql server 2012 or above?

SQLServerCentral » Latest topics

How to check sql 2000 compatibility on sql server 2012 or above?

So, I made a mistake at my company yesterday.  I was assigned to make some stored procedure fixes to one of our older applications, which I had never worked on before.  I made the fix & sent it over to be deployed to production.  What I

more info...

New solar panel creates power from rain, as well as sunlight

Network World Data Center

New solar panel creates power from rain, as well as sunlight

With an upcoming data tsunami expected to absorb up to 20 percent of global electricity by 2025, according to some experts, data center energy sources are a hot talking point — the photovoltaic solar panel being one of the hottest and most viable fossil fuel alternatives.

However, there’s an obvious problem with the solar panel as electricity source: When sunlight drops off on cloudy or rainy days, so does power output.

Chinese scientists, though, think they have a solution, and that’s to develop a generalized hybrid panel that also harnesses the power of rain. It compensates for lack of sun on iffy days and at night.

To read this article in full, please click here

more info...

Stairway to Columnstore Indexes Level 5: Adding New Data To Columnstore Indexes

SQLServerCentral.com Articles

Stairway to Columnstore Indexes Level 5: Adding New Data To Columnstore Indexes

Earlier levels have shown how Columnstore Indexes work effectively with static data. In most tables however, data is hardly ever static. We are constantly inserting new rows, and updating or deleting existing rows. If you think about what this means for a columnstore index, you will realize that this comes with some unique challenges.

more info...

Comic for 2018.04.17

RSSMix.com Mix ID 8239024

Comic for 2018.04.17

New Cyanide and Happiness Comic

more info...

How can a backup taken after DBCC found corruption be good

SQLServerCentral » Latest topics

How can a backup taken after DBCC found corruption be good

I have a corrupt database.  The last log backup_finish_date is 2018-04-17 14:42:27.000 (backup_start_date is 2018-04-17 14:42:25.000) .  I have restored this database backup chain to another server and it DBCC's ok with no errors.

more info...

Cisco boosts IoT access control, management

Network World Data Center

Cisco boosts IoT access control, management

Cisco has rolled out software tools for helping customers control access and more easily manage the burgeoning amount of enterprise IoT devices in their networks. 

The company has also begun filling out its Catalyst 9000 line of intent-based networking (IBN) switches with new boxes aimed at customers wanting 100G/sec and 25G/sec network migration options.

[ For more on IoT see tips for securing IoT on your network, our list of the most powerful internet of things companies and learn about the industrial internet of things. | Get regularly scheduled insights by signing up for Network World newsletters. ] IoT access control, security, management

The need for much better enterprise IoT access control is obvious, Cisco says: According to its Midyear Cybersecurity Report for 2017 most companies are not aware of what IoT devices are connected to their network.

To read this article in full, please click here

more info...

Removing stored procedures to move to cloud

SQLServerCentral » Latest topics

Removing stored procedures to move to cloud

I got an interesting email today about cutting back on the reliance of the applications on databases and plans to remove all stored procedures from the code.
In my opinion, this is nonsense but I  don't feel that it's a good idea to say it like t

more info...

Extended event not capturing queries

SQLServerCentral » Latest topics

Extended event not capturing queries

more info...

Fixing system database corruption with setup.exe

SQLServerCentral.com Articles

Fixing system database corruption with setup.exe

Corruption of the system databases is a serious matter. Setup.exe is a brute force method of replacing them.

more info...

Comic for 2018.04.16

RSSMix.com Mix ID 8239024

Comic for 2018.04.16

New Cyanide and Happiness Comic

more info...

In the IoT world, general-purpose databases can’t cut it

Network World Data Center

In the IoT world, general-purpose databases can’t cut it

We live in an age of instrumentation, where everything that can be measured is being measured so that it can be analyzed and acted upon, preferably in real time or near real time. This instrumentation and measurement process is happening in both the physical world, as well as the virtual world of IT.

For example, in the physical world, a solar energy company has instrumented all its solar panels to provide remote monitoring and battery management. Usage information is collected from a customers’ panels and sent via mobile networks to a database in the cloud. The data is analyzed, and the resulting information is used to configure and adapt each customer’s system to extend the life of the battery and control the product. If an abnormality or problem is detected, an alert can be sent to a service agent to mitigate the problem before it worsens. Thus, proactive customer service is enabled based on real-time data coming from the solar energy system at a customer’s installation.

To read this article in full, please click here

more info...

SQL Server From .Net: Making A Connection

SQLServerCentral.com Articles

SQL Server From .Net: Making A Connection

A basic introduction for developers about creating a connection from .Net to SQL Server, and some of the options available.

more info...

Comic for 2018.04.15

RSSMix.com Mix ID 8239024

Comic for 2018.04.15

New Cyanide and Happiness Comic

more info...

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

more info...

SQL Server on Amazon RDS vs SQL Server on Amazon EC2

SQLServerCentral » Latest topics

SQL Server on Amazon RDS vs SQL Server on Amazon EC2

Comments posted to this topic are about the item [B]SQL Server on Amazon RDS vs SQL Server on Amazon EC2[/B]

more info...

Comic for 2018.04.14

RSSMix.com Mix ID 8239024

Comic for 2018.04.14

New Cyanide and Happiness Comic

more info...

XML Source - D/L from URL

SQLServerCentral » Latest topics

XML Source - D/L from URL

Hi All,
I am trying to download from the following URL,  http://www.rba.gov.au/rss/rss-cb-exchange-rates.xml I have a xml source for the URL directly as well a script task usi

more info...

Comic for 2018.04.13

RSSMix.com Mix ID 8239024

Comic for 2018.04.13

New Cyanide and Happiness Comic

more info...

Localized Upgrades

SQLServerCentral » Latest topics

Localized Upgrades

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

more info...

What is hybrid cloud really, and what's the best strategy?

Network World Data Center

What is hybrid cloud really, and what's the best strategy?

Ask a group of IT leaders to define what a hybrid cloud is, and their answers are likely to be as diverse as the companies they work for. Once a black-and-white definition describing organizations with a mix of apps that reside in both the public cloud and in enterprise data centers, a hybrid cloud has now become much more complicated as the number of apps used in the enterprise grows and their integration requirements mount.  

The average company uses more than 1,400 cloud services, according to Skyhigh Networks, often because lines of business are being pressured to innovate, leaving little time to develop a strategy for the most efficient and cost-effective way to run them.

To read this article in full, please click here

more info...

Believing the Data

SQLServerCentral » Latest topics

Believing the Data

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

more info...

SSIS Design Pattern - Staging Fixed Width Flat Files

SQLServerCentral.com Articles

SSIS Design Pattern - Staging Fixed Width Flat Files

Learn how to load fixed width flat files to staging tables in this article from Samuel Vanga.

more info...

One in five serverless apps has a critical security vulnerability

Network World Data Center

One in five serverless apps has a critical security vulnerability

Serverless computing is an emerging trend that is likely to explode in popularity this year. It takes the idea of a smaller server footprint to the next level. First, there were virtual machines, which ran a whole instance of an operating system. Then they were shrunk to containers, which only loaded the bare minimum of the OS required to run the app. This led to a smaller footprint.

Now we have “serverless” apps, which is a bit of a misnomer. They still run on a server; they just don’t have a dedicated server, virtual machine, or container running 24/7. They run in a server instance until they complete their task, then shut down. It’s the ultimate in small server footprint and reducing server load.

To read this article in full, please click here

more info...

SQL Server on Amazon RDS vs SQL Server on Amazon EC2

SQLServerCentral.com Articles

SQL Server on Amazon RDS vs SQL Server on Amazon EC2

Exploring briefly the difference between using Amazon Machine Images running SQL Server and using SQL Server instances on Amazon's Relational Database Service.

more info...

Comic for 2018.04.11

RSSMix.com Mix ID 8239024

Comic for 2018.04.11

New Cyanide and Happiness Comic

more info...

How to find which SQL Server process was running at a particular time?

SQLServerCentral » Latest topics

How to find which SQL Server process was running at a particular time?

Good Morning Experts,

We received an email from the operations team that they are seeing frequent high CPU alerts on a particular server. These alerts occur around 5:20 AM EST . And, they are saying that high CP

more info...

Intel FPGAs step toward mainstream in Dell, Fujitsu enterprise servers

Network World Data Center

Intel FPGAs step toward mainstream in Dell, Fujitsu enterprise servers

Enterprises should find it easier to tap the benefits of FPGAs now that Dell EMC and Fujitsu are putting Intel Arria 10 GX Programmable Acceleration Cards into off-the-shelf servers for the data center.

Beginning this week, Dell will make programmable acceleration cards with Intel Arria 10 GX FPGAs generally available in the PowerEdge R640, R740 and R740XD servers, and Fujitsu will give priority customers early access to Primergy RX2540 M4 servers with the cards installed.

To read this article in full, please click here

more info...

High CPU usage % on master database

SQLServerCentral » Latest topics

High CPU usage % on master database

Hi,

I have a server with over 1.000 databases and when I checked the most consuming CPU database I got a surprise...
master has over 56% of database usage... Is it because of the high number of databases?

Thanks,
Pedro

more info...

Is the cloud already killing the enterprise data center?

Network World Data Center

Is the cloud already killing the enterprise data center?

“Friends don't let friends build data centers.”

That slogan wasn’t even printed on a real T-shirt you could buy. It was just one of the choices in an online poll to choose what Amazon Web Services CTO Werner Vogels should wear. But it pretty much captured the mood at the AWS Summit San Francisco last week, where Vogels gave the opening keynote to some 9,000 cloud-loving attendees.

On stage, Vogels crowed about multiple enterprises abandoning large numbers of data centers in order to move their workloads to the cloud. He cited Cox Automotive—the company behind Autotrader, Dealer.com, Kelley Blue Book, and many more car-shopping brands—“going all in on AWS” and closing more than 40 data centers. He noted that U.K. news provider News International is shutting down 60 data centers, and GE is closing approximately 30 data centers. And Vogels mentioned that the U.K.’s Ministry of Justice was moving to AWS, as well, though he didn’t say whether it was closing any data centers in the process.

To read this article in full, please click here

more info...

Row-Level Security Predicate Functions - Level 2 of the Stairway to Row Level Security

SQLServerCentral.com Articles

Row-Level Security Predicate Functions - Level 2 of the Stairway to Row Level Security

In this level, we dive deeper into predicates and the various ways to structure them in an RLS environment.

more info...

Comic for 2018.04.10

RSSMix.com Mix ID 8239024

Comic for 2018.04.10

New Cyanide and Happiness Comic

more info...

ICQ: 740104476 Sell CCV,CVV Good Hight Balance 2018 - Fullz - Dumps - Paypal

SQLServerCentral » Latest topics

ICQ: 740104476 Sell CCV,CVV Good Hight Balance 2018 - Fullz - Dumps - Paypal

Hi All
My name Mannequin .
I have Service Online and I'm looking for good buyer to work together for long
I'm a hacker and legit businessman
I have over 10 years of experience in hacker's world
Motto of work : Prestigious is top - Cust

more info...

Cisco broadens Tetration security delivery with cloud, virtual buying options

Network World Data Center

Cisco broadens Tetration security delivery with cloud, virtual buying options

Cisco has added new cloud and virtual deployment options for customers looking to buy into its Tetration Analytics security system.

Cisco’s Tetration system gathers information from hardware and software sensors and analyzes it using big-data analytics and machine learning to offer IT managers a deeper understanding of their data center resources.

[ Don’t miss customer reviews of top remote access tools and see the most powerful IoT companies . | Get daily insights by signing up for Network World newsletters. ]

Tetration can improve enterprise security monitoring, simplify operational reliability, give customers a single tool to collect consistent security telemetry across the entire data center and analyze large volumes of data in real time.  

To read this article in full, please click here

more info...

Shrinking log file

SQLServerCentral » Latest topics

Shrinking log file

Today we have  received   issue that one of the log file in  a database is grown up ot 1.2 TB  and the database is  configured in  transactional replication . how can we  shrink the log file wit out effecting the re

more info...

TRIM() in T-SQL

SQLServerCentral.com Articles

TRIM() in T-SQL

The T-SQL language expanded in SQL Server 2017 with the TRIM() function.

more info...

Comic for 2018.04.09

RSSMix.com Mix ID 8239024

Comic for 2018.04.09

New Cyanide and Happiness Comic

more info...

Overclock puts your idle servers to work for other people

Network World Data Center

Overclock puts your idle servers to work for other people

Putting unused CPUs to work is nothing new. In the modern era, it started in 1999 when the SETI Institute launched SETI@Home, a screensaver that also examined slices of radio signals gathered by a giant telescope for signs of intergalactic life. Nineteen years later, and ET still hasn’t phoned us.

But the concept grew to dozens of science and math-related projects. I took part in the World Community Grid run by IBM for years, letting my idle PC look for potential cures for AIDS and Ebola.

To read this article in full, please click here

more info...

Avoiding Unexpected Results with DATEDIFF in Year Comparisons

SQLServerCentral.com Articles

Avoiding Unexpected Results with DATEDIFF in Year Comparisons

Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.

more info...

Find end user who is running sql query using SQLCMD.

SQLServerCentral » Latest topics

Find end user who is running sql query using SQLCMD.

Hello Folks,

 I'm trying to find a user/developer who is trying to execute queries using SQLCMD. When I check using DMVs, the user is using an application account not domain account. Also SQLCMD is running from the db server. But no one has

more info...

ADO .NET Excel

SQLServerCentral » Latest topics

ADO .NET Excel

Hi All,
I am using a for each loop with a data flow task that is using a ADO .NET for the excel files connection (excel connector is not working). The loop and ADO net connector loop through the 3 files in the source folder but it is loading the

more info...

Comic for 2018.04.08

RSSMix.com Mix ID 8239024

Comic for 2018.04.08

New Cyanide and Happiness Comic

more info...

Comic for 2018.04.07

RSSMix.com Mix ID 8239024

Comic for 2018.04.07

New Cyanide and Happiness Comic

more info...

SSL Certificate for SQL Server 2016 not appearing in MMC

SQLServerCentral » Latest topics

SSL Certificate for SQL Server 2016 not appearing in MMC

Dear Everyone
I followed the required steps to request a certificate for using SSL in SQL Server 2016 and i generated the request file for a PERSONAL store and then imported it into the Personal store but when i do the import and restart the Database

more info...

Comic for 2018.04.06

RSSMix.com Mix ID 8239024

Comic for 2018.04.06

New Cyanide and Happiness Comic

more info...

emp logindetails based on conditions in sql server

SQLServerCentral » Latest topics

emp logindetails based on conditions in sql server

I have a question about SQL Server. Please tell me how to solve login and logout time calculation in SQL Server based on conditions.

If the same empid works multiple shifts, multiple shifts calculation for same date must be time difference is 5 h

more info...

New distributed database adds international and GDPR controls

Network World Data Center

New distributed database adds international and GDPR controls

The European Union’s General Data Protection Regulation (GDPR) will force very strict new privacy compliance rules on firms doing business in the EU, but a startup that has an atrocious company and product name has what it says is the solution to maintaining compliance.

Cockroach Labs has introduced version 2.0 of its CockroachDB distributed database, which can be run in a data center or cloud. The company bills the product as “the SQL database for global cloud services.” It automatically scales, rebalances, and repairs databases spread over multiple locations.

To read this article in full, please click here

more info...

How to execute a Powershell script via SSIS

SQLServerCentral.com Articles

How to execute a Powershell script via SSIS

Learn how you can execute a PowerShell script via the SSIS execute process task.

more info...

Question about sys.certificates

SQLServerCentral » Latest topics

Question about sys.certificates

Hi All,

Can anyone explain to me the actual purpose of the thumbprint field when selecting from sys.certificates? How sensitive is the data stored in that field?

Thanks,

Mike

more info...

IDG Contributor Network: The serverless cloud provider was last year – what can we expect to change?

Network World Data Center

IDG Contributor Network: The serverless cloud provider was last year – what can we expect to change?

Reno-based analyst Synergy Research Group released a review of the 2017 cloud market on January 4th. The report, which estimated the total scope of the industry at $180 billion, gauged the year-over-year growth rate of infrastructure as a service (cloud hosting) and platform as a service (combined cloud hardware and software) at 47%. Such astronomical growth in the infrastructure of cloud is fueling growth of data centers. The extent to which cloud is becoming the new form of infrastructure cannot be overstated, with Cisco predicting 95% of data center traffic will be through cloud infrastructure by 2021.

To read this article in full, please click here

more info...

Cosmos DB Webinars

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

Cosmos DB Webinars

Microsoft has a new set of on demand webinars to teach you how to use Azure Cosmos DB. Register for them here . You can download the latest version of the Cosmos DB emulator from here . I like it because it can be used offline (great way to learn on those long airplane trips) and doesn’t occur any Azure usage charges since it is a local application....(read more)

more info...

In Memory of Robert

SQLServerCentral » Latest topics

In Memory of Robert

Comments posted to this topic are about the item [B]In Memory of Robert[/B]

more info...

Scripting Tables and Procedures from SSMS

SQLServerCentral.com Articles

Scripting Tables and Procedures from SSMS

Learn how you can script specific objects from SSMS and store or update them in a git repository.

more info...

Comic for 2018.04.04

RSSMix.com Mix ID 8239024

Comic for 2018.04.04

New Cyanide and Happiness Comic

more info...

ICHIGO - ICQ: 729778218 Sell CVV GOOD 2018 Updates CC Fullz

SQLServerCentral » Latest topics

ICHIGO - ICQ: 729778218 Sell CVV GOOD 2018 Updates CC Fullz

ICQ: 729778218 Sell CVV GOOD 2018 Updates CC Fullz + Dumps Tracks 1.2
WELCOME ALL CUSTOMERS WITH CARDERS WORLD 

WE NEED A LONG TERM BUSINESS? 

Credit Card Debi

more info...

Data Modeling for Power BI available as video recorded course

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

Data Modeling for Power BI available as video recorded course

The Data Modeling for Power BI training is now available as a video recorded course, including exercises!Take advantage of the launch offer until April 17, 2018.Read more about this:Why Data Modeling is important in Power BIThe new Data Modeling for Power BI courseData Modeling training guide

more info...

Free eBook: Inside the SQL Server Query Optimizer

SQLServerCentral.com Articles

Free eBook: Inside the SQL Server Query Optimizer

This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.

more info...

I need to divide my total by the QTY, but QTY lives on every row

SQLServerCentral » Latest topics

I need to divide my total by the QTY, but QTY lives on every row

I hope i explain this correctly
I am dealing with BoMs . . .
If there are 50 rows of parts, for example, on a BoM where the BoM QTY is 6, I need to divide the total of my 50 lines of duty per part by 6.  If the BoM Qty is 60, i need to divid

more info...

Comic for 2018.04.03

RSSMix.com Mix ID 8239024

Comic for 2018.04.03

New Cyanide and Happiness Comic

more info...

Product–services bundles boost AI

Network World Data Center

Product–services bundles boost AI

The infrastructure required to run artificial intelligence algorithms and train deep neural networks is so dauntingly complex, that it’s hampering enterprise AI deployments, experts say.

“55% of firms have not yet achieved any tangible business outcomes from AI, and 43% say it’s too soon to tell,” says Forrester Research about the challenges of transitioning from AI excitement to tangible, scalable AI success.

[ 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. ]

“The wrinkle? AI is not a plug-and-play proposition,” the analyst group says. “Unless firms plan, deploy, and govern it correctly, new AI tech will provide meager benefits at best or, at worst, result in unexpected and undesired outcomes.”

To read this article in full, please click here

more info...

Cache Snapshots And History Snapshots in SSRS 2016

SQLServerCentral.com Articles

Cache Snapshots And History Snapshots in SSRS 2016

The various Snapshot options in Reporting Services 2016 explained.

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...

Comic for 2018.04.02

RSSMix.com Mix ID 8239024

Comic for 2018.04.02

New Cyanide and Happiness Comic

more info...

Db name inside the stored proc

SQLServerCentral » Latest topics

Db name inside the stored proc

All,

I am trying to work on a stored proc that would accept DB as a parameter name and then work its way down creating views and triggers etc. However, the point where I am stuck is I couldn't make it switch to use a different database name insid

more info...

Ranking Products based on Location and NET Quantity

SQLServerCentral » Latest topics

Ranking Products based on Location and NET Quantity

Hello,

I am looking to create a query so that we can identify top 3 selling parts by Store  based on the Net Quantity sold.  Below I have created sample data, can someone help me understand how I can efficiently query this for

more info...

Storing a variable with a SELECT, and why it didn't work.

SQLServerCentral.com Articles

Storing a variable with a SELECT, and why it didn't work.

Using SELECT to store values into variables is an important technique, but you need to know some of the gotchas as well.

more info...

Comic for 2018.04.01

RSSMix.com Mix ID 8239024

Comic for 2018.04.01

New Cyanide and Happiness Comic

more info...

free download Certqueen H13-612-ENU exam questions

SQLServerCentral » Latest topics

free download Certqueen H13-612-ENU exam questions

44.What is the function of Tagged (or Native) Command Queuing?
A. Have the device process the commands internally and during that time release the bus.
B. Have multiple devices s

more info...

Comic for 2018.03.31

RSSMix.com Mix ID 8239024

Comic for 2018.03.31

New Cyanide and Happiness Comic

more info...

Where conditions

SQLServerCentral » Latest topics

Where conditions

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

more info...