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

Latest Blog Posts

How to Find SQL Server Performance Bottlenecks and Fix These Issues

SQL Server is undoubtedly a popular way to manage database. Due to its efficiency, business organizations largely depend on this for data management. This dependency often causes performance bottlenecks and ultimately hampers the productivity of the organization itself. So, it is important to find the bottlenecks and avoid them at…

Read more

0 comments, 76 reads

Posted in SQL Server Overview on 17 November 2018

How to Write a Better T-SQL Code

Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are aimed for the beginner-level T-SQL developers.

Always Use a Schema for the Programmable Objects

For example, instead of writing BillOfMaterial you should have dbo.BillOfMaterial in a query.
Having SELECT… Read more

0 comments, 94 reads

Posted in Si vis pacem, para sql on 16 November 2018

Meetings: Have a Point of Focus

Have you ever been in a meeting where the attendees seemed to go down one rabbit trail after another? At the end of that meeting, likely everyone left wondering why they were there. Those meetings are failed meetings. Meetings should move things forward. Otherwise, what’s the point? And that gets… Read more

0 comments, 68 reads

Posted in Databases – Infrastructure – Security on 16 November 2018

Subscribe to our RSS Feed

Be sure to subscript to our RSS feed to keep up with the latest SQL Server news and tips!

http://vitamindba.com/feed/

 

The post Subscribe to our RSS Feed appeared first on VitaminDBA.

Read more

0 comments, 74 reads

Posted in vitamindba on 16 November 2018

ASF 016 video invitation

“Power BI is just growing and growing and getting better and better at an amazing rate.” Who said that? Watch the video trailer and guess who is the next guest.

Source Read more

0 comments, 72 reads

Posted in SQL Player Blog on 16 November 2018

Load SQL error log to a table

SQL server error log load to a table

There are cases, we need a SQL server error log load to a table for troubleshooting. Since there will be a more informational message and logon enabled etc.

Here is the script to load and read.

-- create table 

use dba
go…

Read more

0 comments, 82 reads

Posted in SQL Server Blog Forum on 16 November 2018

Power BI Visual Usability Checklist

At PASS Summit, I presented a session called “Do Your Data Visualizations Need a Makeover?”. In my session I explained how we often set ourselves up for failure when conducting explanatory data visualization before we ever place a visual on the page by not preparing appropriately, and I provided tips… Read more

0 comments, 99 reads

Posted in Data Savvy on 15 November 2018

Fun with Savepoints–#SQLNewBlogger

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

I haven’t spent a lot of time with savepoints, but I did find a question recently and thought I’d take a moment to dig into how they work.… Read more

0 comments, 125 reads

Posted in The Voice of the DBA on 15 November 2018

Determine database version from a bak file

Have you ever imagine you can determine the version of SQL Server from a bak or a MDF file? I have been in situations where I received a bak or MDF and LDF files from a vendor to restore \ create a database for the implementation of a new application,… Read more

0 comments, 91 reads

Posted in DBA Mastery on 15 November 2018

Monitor Database Offline Events

The other day, I shared an article showing how to audit database offline events via the default trace. Today, I will show an easier method to both audit and monitor for offline events. What is the difference between audit and monitor? It largely depends on your implementation, but I… Read more

0 comments, 106 reads

Posted in SQL RNNR on 15 November 2018

Parameterized dynamic SQL is parameterized.

Ok, that title sounds silly, but it’s actually a real point. The first parameterized refers to using parameters within dynamic SQL, while the second refers to how the optimizer treats parameters differently from variables. When you use parameterized dynamic SQL with sp_executesql SQL server treats the parameters as actual parameters not… Read more

3 comments, 107 reads

Posted in SQLStudies on 15 November 2018

Microsoft Professional Program vs Microsoft Certification

When learning new technologies many people will go towards training courses (in person or online) but many also go for certifications such as MCSA / MCSE, which I no longer pursue for many reasons. Microsoft now have this idea of … Continue reading

Read more

2 comments, 135 reads

Posted in All About SQL on 15 November 2018

TSQL Tuesday #108 – Learning to Learn

G’day,

One attribute that I think is more relevant today than ever is to have a broad base of skills with the ability to go deep when needed.

This requires the ability to learn quickly when needed.  Which, in turn, requires that we know how to learn quickly.

When I… Read more

0 comments, 91 reads

Posted in measure twice, cut once. on 15 November 2018

Switching blog website

For quite some years now I have been active on my blog over at www.dotnine.net. While there was nothing wrong with blogging through that URL I frequently got some feedback that my blog posts were difficult to find. People don’t directly associate DotNine with SQL Server, analytics or my… Read more

0 comments, 115 reads

Posted in DotNine SQL Server and more on 14 November 2018

Dates and Times in SQL Server: DATEADD()

We are now in the home stretch of the long-running series about dates and times in SQL Server and Azure SQL Database. This week we look at one of my favourite T-SQL functions when it comes to dates and times: DATEADD(). Syntax As with similar functions, DATEADD can do arithmetic… Read more

0 comments, 121 reads

Posted in Born SQL with Randolph West on 14 November 2018

Power BI Monthly Digest – November 2018

In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI updates this month. In our November 2018 edition we highlighted the following features:

    • Expand and Collapse Matrix
    • New Filter Experience (preview)

Read more

0 comments, 175 reads

Posted in Devin Knight on 14 November 2018

Azure SQL Database – Fixing My Scaling Failure

This is kind of a follow up from my last blog post about a scale down request issue. (https://blobeater.blog/2018/11/07/azure-sql-database-aborting-scale-request/) I was confused, so confused that I ended up logging a support request with Microsoft. The issue was I wanted to … Continue reading

Read more

2 comments, 142 reads

Posted in All About SQL on 14 November 2018

T-SQL Tuesday #108 – Non SQL Server Technologies

It’s T-SQL Tuesday #108. This month’s topic is hosted by Malathi Mahadevan (B|T) and she asks us to… “pick one thing you want to learn that is not SQL Server. Write down ways and means to learn it and add it as another skill to your resume. If you are… Read more

0 comments, 105 reads

Posted in SQL Player Blog on 13 November 2018

T-SQL Tuesday #108: New Horizons Beyond SQL Server

There comes a point in one’s career when a change is requisite. Big or small there always seems to be a tipping point that mandates some sort of change. Maybe the change is an entirely new career field. Maybe the change is adapting to the ever improving features of a… Read more

0 comments, 147 reads

Posted in SQL RNNR on 13 November 2018

Learning Better Presentation Skills (T-SQL Tuesday #108)

This month’s T-SQL Tuesday is hosted by Malathi Mahadevan (@SqlMal). The topic is to pick one thing I would like to learn that is not SQL Server.

I’m going to go a different direction than I think most people will. I spend a lot of time learning… Read more

0 comments, 124 reads

Posted in Data Savvy on 13 November 2018

Older posts