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

Latest Blog Posts

I’m speaking: SQL Saturday Los Angeles 06-09-18

Hello California! I’m headed your way and will be speaking at SQL Saturday #773. The full schedule is live and there are a lot of great speakers to check out. If you’re in LA or the surrounding area on June 9th be sure to check it out. The event… Read more

0 comments, 100 reads

Posted in Confessions of a Microsoft Addict on 14 May 2018

Monday morning comic 2018-05-18

Here’s the first issue of a new Monday morning comic series. Hopefully some of you all get a giggle.

Read more

0 comments, 107 reads

Posted in Confessions of a Microsoft Addict on 14 May 2018

Reaching the Refactoring Redoubt with #SQLPrompt

I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes and go through it. I wrote about Code Snippet Cove first, and this post finishes my movement around the map. The other items I’ve read about are:

Read more

0 comments, 136 reads

Posted in The Voice of the DBA on 14 May 2018

Handy TSQL for Azure SQL Database

I do not always use the Azure portal to make database changes or to check for certain information. I use it a lot of for blogging purposes but for some tasks I rather just run code via SSMS – SQL Server Management Studio.

Like what?

Creating a database

Very easy… Read more

0 comments, 172 reads

Posted in All About SQL on 14 May 2018

A View Will Not Make Your Query Faster

Twice recently, one on a blog post, and one in a forum post, I’ve seen people state, unequivocally, without reservation or hint of a caveat, that, “Oh, just put that query into a view. It will run faster.”

To quote the kids these days…

Time for a rant.

But First…

Read more

8 comments, 130 reads

Posted in The Scary DBA on 14 May 2018

Day 14 MySQL sys Schema

MySQL 5.7.7 and higher includes the sys schema, This has View, Stored Procedures and Functions to gather the performance related information, as it works on Performance Schema the Performance Schema must be enabled for the sys database. Following some of the important tables: sys_config: … Continue reading

Read more

0 comments, 81 reads

Posted in Vinay Thakur on 14 May 2018

Blogging and when to keep your big mouth shut

I’ve been blogging for a while now. I’ve thought about blogging quite a bit. I’ve even done quite a few blogs about blogging. I’ve talked about blogging problems, and I’ve talked about deciding what to blog about. I even have my own list of blogging ideas posted publicly… Read more

1 comments, 109 reads

Posted in SQLStudies on 14 May 2018

Microsoft Azure – Azure Mobile App is available now

Hello friends, Please check the below link for my new post on Microsoft Azure Mobile App. https://social.technet.microsoft.com/wiki/contents/articles/51525.microsoft-azure-mobile-app-is-available-now.aspx Advertisements

Read more

0 comments, 165 reads

Posted in Kapil Blogs on 14 May 2018

Day 13 MySQL Performance_Schema

performace_schema is a dynamic database created when you restart the mysql, all the data from performance_schema database will be clear. This database has its own storage engine –“performance_schema” Even you may have this database but it could be possible that … Continue reading

Read more

0 comments, 112 reads

Posted in Vinay Thakur on 13 May 2018

Find Query with Implicit Conversion in the Plan Cache

In my previous blog, I discussed about Which are the queries using a particular index or table?. Today’s post, I am going to show how you can find all queries with Implicit Conversion in SQL Server.

What is an implicit conversion?

Implicit conversions occur whenever data with… Read more

0 comments, 155 reads

Posted in SQL Geek on 13 May 2018

Day 12 INFORMATION_SCHEMA database

Yesterday we discuss about mysql system database, today we will see “INFORMATION_SCHEMA” database, this we cannot call as database because it is not stored any data directly, it provides information about metadata and other information which mysql has – data … Continue reading

Read more

0 comments, 131 reads

Posted in Vinay Thakur on 12 May 2018

Day 11 MySQL System Database

Previous days we discuss Variables and configurations which are quite important for DBA to know. As stated earlier there are some system database MySQL has which will also contains very important information. Now on we will spend some time on … Continue reading

Read more

0 comments, 126 reads

Posted in Vinay Thakur on 11 May 2018

Mssql-cli Command-Line Query Tool

A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements and business are almost always a trade-off, and striking the right balance in a product in terms of the toolset is a sign of a successful product. After testing the SQL… Read more

0 comments, 160 reads

Posted in PowerSQL By Prashanth Jayaram on 11 May 2018

YouTube Channel Update: 11 May 2018

I’ve been busy getting the videos up on YouTube. If they’re helpful to you, please subscribe. Some point soon I’ll start doing some livestreams, maybe from different events, or during a presentation. If you’re subscribed, you’ll know about it when it happens.

Videos

We’re getting closer and closer to… Read more

0 comments, 109 reads

Posted in The Scary DBA on 11 May 2018

Microsoft Build event announcements

Another Microsoft event and another bunch of exciting announcements.  At the Microsoft Build event this week, the major announcements in the data platform space were:

Multi-master at global scale with Azure Cosmos DB.  Perform writes on containers of data (for example, collections, graphs, tables) distributed anywhere in the world.… Read more

1 comments, 346 reads

Posted in James Serra's Blog on 11 May 2018

DMV To List Foreign Keys With No Index

I was entrusted with a new database for a critical application that was having general performance issue and the CPU usage constantly over 70%.

It turned out that I did not have to sweat much to quickly and significantly improve the database performance and also bring down CPU % way…

Read more

6 comments, 774 reads

Posted in Mission: SQL Homeostasis on 10 May 2018

How To Audit Data Changes In SQL Server?


Scenario:

I was at a new client, with their previous and only DBA / DEVELOPER/ MASTER OF ALL of 8 years all suddenly gone with no documentation.

Their business critical application was having data integrity issues. Some data were updated incorrectly while some others were not updated at all, showing…

Read more

0 comments, 844 reads

Posted in Mission: SQL Homeostasis on 10 May 2018

Finding Tabs in SSMS–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

Someone posted this as a question and I thought it was worth noting. I use SQL Prompt for formatting, and never worry if there are tabs in code,… Read more

0 comments, 172 reads

Posted in The Voice of the DBA on 10 May 2018

Day 10 Option file

So far we have discussed various mays to configure MySQL, Environmental Variables, Global Variable, Session Variables, Status Variable and Server Variables. All this variables are important and set the variable some of them dynamically affects the system and some required … Continue reading

Read more

0 comments, 109 reads

Posted in Vinay Thakur on 10 May 2018

PASS Summit 2018 Pre-con: Digital Storytelling with Power BI

Mitchell Pearson, Brian Knight and myself will be presenting a full day pre-con as PASS Summit on Digital Storytelling with Power BI. You can learn more about it here: http://www.pass.org/summit/2018/Sessions/Details.aspx?sid=80300

Read more

0 comments, 530 reads

Posted in Devin Knight on 10 May 2018

Newer posts

Older posts