Popular Posts

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

Tuesday, July 25, 2017

Microsoft’s cloud revenue grows, while IBM’s fades

Network World Data Center
Microsoft’s cloud revenue grows, while IBM’s fades

This is a tale of two cloud players, both old-guard IT firms with vested interests in on-premises software sales. One is making a very successful transition to the cloud era, while the other is failing badly. And it’s a familiar story. Microsoft is kicking butt, and IBM is getting its butt kicked.

In its most recent quarter, Microsoft announced revenues of $23.3 billion, $7.43 billion of that comes from what it calls “the Intelligent Cloud,” including Azure, a 97 percent year-over-year increase. There was another $8.45 billion from the Productivity and Business Process business, which includes Office and Office 365. The company did not separate out the installed software sales from the on-demand version, but it did say that for the first time, Office 365 is outselling the on-premises version.

To read this article in full or to leave a comment, please click here

Next row begins

SQLServerCentral » Latest topics
Next row begins
Ok so what I am wanting to do is fill in rows with information that is missing from a file. I read a file insert it into a table but there is data missing from the file format. I've added an excel file so it's easier to understand what I am trying to acco

Fantasy Football 2017

SQLServerCentral » Latest topics
Fantasy Football 2017
Placeholder for the 2017 league. Congrats to the 2016 winners: Ray K - $100 SequelSurfer - $75 Steve Jones - $50 I'll do the same prizes next year. Everyone from 2016 has first crack at the league (12 teams), but if you're interested in joining, l

time - missing colon :

SQLServerCentral » Latest topics
time - missing colon :
i have received a legacy data files from vendor time values are sent without semicolon , can you help me how to add semicolon to it.

[code language="sql"]create table #temp (col1 varchar(15))

SQL AlwaysOn install requirements

SQLServerCentral » Latest topics
SQL AlwaysOn install requirements
Hi there,

What are the install requirements for SQLAlwaysOn?eg. Database Engine and ..... Some install videos on youtube have the Database Engine and SQL Server Replication selected but others only have the Database Engine selected for the instal

Comic for 2017.07.25

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

Production DBA Vs Project/Development DBA

SQLServerCentral » Latest topics
Production DBA Vs Project/Development DBA
Hi, Does anybody have any reference points for how the role of a production DBA may differ from that of a project or development DBA? My previous experience has been in companies where either there was only a couple of DBA's doing everything, or in

My db has a lot of PAGELATCH_SH waits going on

SQLServerCentral » Latest topics
My db has a lot of PAGELATCH_SH waits going on
Hi all, Hope this topic is in the right area. 

I have a highly normalized Dynamics AX database, and lately there are a lot of PAGELATCH_SH waits going on in it. The transaction db and logs are on the same spindles, the temp db is on its own

Comic for July 20, 2017

RSSMix.com Mix ID 8239024
Comic for July 20, 2017
Dilbert readers - Please visit Dilbert.com to read this feature. Due to changes with our feeds, we are now making this RSS feed a link to Dilbert.com.

Track User level metadata changes in SQL Server

SQLServerCentral » Latest topics
Track User level metadata changes in SQL Server
Scenario is one of db user(employee) resigns his job, i need to track the metadata changes done by that db user, any script please suggest
Note: i have not enabled CDC

snapshot restores getting slower

SQLServerCentral » Latest topics
snapshot restores getting slower
Hi, in one of our test environments I've noticed snapshots restores are taking 4 x the amount of time they where taking a couple of weeks ago .. any ideas as to where to look for root cause ?
some (hopefully)  pertinent info ;

Formatting in HTML table

SQLServerCentral » Latest topics
Formatting in HTML table
Hi guys, I have created a HTML table dynamically to send on mail. That table contains few amount columns. It's something like:

Declare @htmltable varchar(max)
Select @htmltable = '<table border="1">

Comic for 2017.07.25

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

Monday, July 24, 2017

Deploying, Securing, and Updating Power BI Reports

SQLServerCentral.com Articles
Deploying, Securing, and Updating Power BI Reports

Before Excel and other data-linked spreadsheets, business reports needed to be hand-crafted by IT experts, and changes were arbitrated slowly via change control. Power BI was designed to take the liberation that Excel pioneered to the max, by allowing 'power' users to not only to create Power BI desktop reports, graphics and visualisations in Power BI App, but then link and publish these to the Power BI app. These in turn can be given row level security and have their underlying data kept up-to-date so that users can log in and see the relevant and appropriate data in a browser. Saurabh Desai shows how.

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.

SQL Server geo-cluster 2016

SQLServerCentral » Latest topics
SQL Server geo-cluster 2016

Dear Everyone
Ikeep reading online that its not recommended to virtualize SQL Server clusters (4 nodes)