-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

Backup Linux/windows SQL Server databases using PowerShell and Windows task scheduler

 

This article is an in-depth guide on how PowerShell can be used to maintain and manage SQL backup on Linux and Windows machines.

Here’s an outline of what this article is all about:

  • Introduction
  • Technical specifications
  • How to load SQL Server modules on Windows machine
  • Security – Credential Management

Read more

0 comments, 433 reads

Posted in PowerSQL By Prashanth Jayaram on 22 May 2018

SQL Saturday – Dallas – May 2018

I was able to present at SQL Saturday Dallas this year. Thanks to those of you who were able to attend. As I noted in the meeting you can find details related to Power BI Data Security in the following posts on my site.

Power BI Is Finally in the… Read more

0 comments, 80 reads

Posted in DataOnWheels on 22 May 2018

SQL Saturday Iowa City Precon June 22

I’m extremely proud to announce that I have been selected to present an all-new preconference training session on Friday, June 22, ahead of the SQL Saturday in Iowa City, Iowa. This all-day training class, entitled “Level Up Your Cloud Infrastructure Skills“, is designed to help you,… Read more

0 comments, 104 reads

Posted in Technobabble by Klee from @kleegeek on 22 May 2018

Update Oddness for SQL Server

I’ve been meaning to patch some of my development instances. With a little spare time while doing other work, I started the process the other day. My first step was to patch SQL Server 2016 with SP2.

This went as many patches have gone for me, which is fairly boring… Read more

2 comments, 139 reads

Posted in The Voice of the DBA on 22 May 2018

Azure SQL Database / SQL Server – Paused Index Rebuild

I was creating some demo non-clustered indexes in one of my Azure SQL Databases and received the following warning when I executed this code:

CREATE NONCLUSTERED INDEX [dbo.NCI_Time]
ON [dbo].[Audit] ([UserId])
INCLUDE ([DefID],[ShopID])

Msg 10637, Level 16, State 3, Line 7

Cannot perform this operation on ‘object’ with ID 1093578934… Read more

1 comments, 437 reads

Posted in All About SQL on 22 May 2018

Azure PowerShell – List Data Center Locations

Occasionally I will come across the need to use PowerShell for my day to day activities. One such need came up this week when I was preparing to do training with a customer. Part of that meant creating 6 data science VMs. So we updated the software on a VM… Read more

0 comments, 108 reads

Posted in Bradley Schacht on 22 May 2018

Power BI Custom Visuals Class (Module 104 – User List by CloudScope)

In this module you will learn how to use the User List by CloudScope. The User List by CloudScope is designed for showing a list of data presented in the format of a Twitter profile.

Module 104 – User List by CloudScope

Downloads

Read more

0 comments, 512 reads

Posted in Devin Knight on 22 May 2018

Converting JSON to SQL Server CREATE TABLE Statements

Watch this week’s episode on YouTube.

Tedious, repetitive tasks are the bane of any lazy programmer.  I know, because I am one.

One such repetitive task that I find comparable to counting grains of rice is building database layouts from JSON data sources.

While some online services exist that will… Read more

0 comments, 529 reads

Posted in Bert Wagner on 22 May 2018

Day 22 Other Storage Engines

So far we have discussed InnoDB, MyIASM and NDB Storage engine which are most standard/common and important storage engine MySQL has, there are some other Storage engine which are specific to the business requirement and used only for their special … Continue reading

Read more

0 comments, 78 reads

Posted in Vinay Thakur on 21 May 2018

Monday morning comic 2018-05-21

I decided to poke fun at ORM tools again this week. Hope you enjoy.

Read more

0 comments, 106 reads

Posted in Confessions of a Microsoft Addict on 21 May 2018

Linux LFCE Learning Path Available at Pluralsight

I’m proud to announce the completion of my first Pluralsight Learning Path. This learning path is built to advance your Linux knowledge to the system administrator or system engineer level. In this series of courses you’ll learn the theory behind how things work and also practice demonstrations and tips to… Read more

0 comments, 109 reads

Posted in Anthony Nocentino's Blog on 21 May 2018

Day 21 NDB Storage Engine (Cluster)

MySQL also support High Availability, NDB Storage engine provides high availability- shared-nothing system, NDB Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (which stands for “Network DataBase” NDB Cluster required 3 Nodes required complete the setup: Management node(mgmd): … Continue reading

Read more

0 comments, 89 reads

Posted in Vinay Thakur on 21 May 2018

Why PASS?

In case this is your first time hearing of it, PASS is the single largest community of Microsoft Data Platform professionals on the planet. It consists of local groups, virtual groups, multiple online events, SQLSaturday, and, to pay for it all, PASS Summit. However, that’s… Read more

0 comments, 424 reads

Posted in The Scary DBA on 21 May 2018

SQLpassion Online Trainings in June 2018

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I want to announce my SQLpassion Online Training for June 2018.

On June 21, 2018 I’m… Read more

0 comments, 98 reads

Posted in Klaus Aschenbrenner on 21 May 2018

Tactics to Find Outdated Statistics in SQL Server

Statistics in SQL Server are used to identify the type of plan that needs to be executed for a query. SQL Server is pretty good in estimating the statistics. But, there are some circumstances in which it does not, in that case, a better understanding of statistics is required. Moreover,… Read more

0 comments, 143 reads

Posted in SQL Server Overview on 21 May 2018

What are the system databases?

I get to help with technical interviews every now and again, and one of the questions we always ask is “What are the system databases, and what are they for.” It’s a nice easy softball of a question. Or at least so I always thought until I started using it.… Read more

4 comments, 118 reads

Posted in SQLStudies on 21 May 2018

Day 20 Innodb Storage engine

InnoDB is the major Storage engine and is default Storage engine after MySQL 5.5 version. As standard RDBMS requires ACID properties and to make the Enterprise level of the system requires Transaction management. Before this MySQL was known to be … Continue reading

Read more

0 comments, 89 reads

Posted in Vinay Thakur on 21 May 2018

SQL Server Stress Testing Using OStress – RML Utilities

As a DBA, implementing a new database consists of a variety of aspects like correct table structure, tuning the stored procedures, creating right indexes, and many more. But all of these items, the stress testing and performance benchmarking play one of the most crucial roles. There are many tools available… Read more

0 comments, 518 reads

Posted in SQL Geek on 21 May 2018

Power BI with Maps: Choose Your Destination

(2018-May-20) A childhood dream to travel around the world fueled by reading Gulliver's Travels stories and Robinson Crusoe attempts to survive on a deserted island. Those books were filled with geographical description and map locations. I think I always loved working with maps and I still do! There is something that could captivate…

Read more

1 comments, 195 reads

Posted in Data Adventures on 20 May 2018

C# – Read emails from exchange online mailbox (Office 365) into SQL Server

You have an Office 365 mailbox. You want to use C# to read those mails and save them to SQLServer.

The post C# – Read emails from exchange online mailbox (Office 365) into SQL Server appeared first on SQLTreeo.

Read more

0 comments, 102 reads

Posted in SQL Treeo on 20 May 2018

Newer posts

Older posts