Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

Show AutoGrowth Events with Powershell to CSV

This week I was reading Pinal Daves post about Autogrowth Events

http://blog.sqlauthority.com/2015/02/03/sql-server-script-whenwho-did-auto-grow-for-the-database/

as it happened I had a requirement to make use of the script only a few days later. I was asked to provide the information in a CSV so that the person who required the information could manipulate… Read more

0 comments, 3,933 reads

Posted in SQL DBA With A Beard on 15 February 2015

Outlier Detection with SQL Server, part 3.5: The Modified Thompson Tau Test

By Steve Bolton

…………Based on what little experience I’ve gained from writing this series on finding outliers in SQL Server databases, I expected the Modified Thompson Tau test to be a clunker. It marries the math underpinning one of the most ubiquitous means of outlier detection, Z-Scores, with the… Read more

0 comments, 4,533 reads

Posted in Multidimensional Mayhem on 14 February 2015

Friday Followup For February 13, 2015

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Building (for FREE) a Virtual Server for SQL Demos
  • Cheating DBCC To Fix Index Corruption
  • Do You Need…

Read more

0 comments, 117 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 13 February 2015

tSQLt – SQLCop – Checking Naming Conventions

I’ve been using tSQLt a bit to do some testing and one of the things I’ve tested is standards for code. I’ve been using a framework on top of tSQLt called SQLCop. These are a series of tests written to look for specific things. One of the items I… Read more

0 comments, 4,713 reads

Posted in The Voice of the DBA on 12 February 2015

Please Throw this Hardware at the Problem

We’re being told over and over that “throwing hardware at the problem” is not the correct solution for performance problems and a 2x faster server will not make our application twice as fast. Quite true, but there’s one thing that we can do very easily without emptying the piggy bank… Read more

7 comments, 5,684 reads

Posted in SpaghettiDBA on 12 February 2015

TSQL Tuesday #63 – How do you manage security: Rollup

When I decided on security as my topic for February’s T-SQL Tuesday blog party my thought was that security was a topic everyone would have something to say about as it’s something that touches the lives of every DBA at some level or another. Well it turns out I was… Read more

1 comments, 205 reads

Posted in SQLStudies on 12 February 2015

How to configure memory in SQL SERVER ? TIP#83

 

One of the good sentence I remember “When someone has teeth he/she is not having nuts and when someone has nuts he/she not having teeth”. Just joke a part. You understand what I mean to say here. If you have the resources then utilize it.

One of the most… Read more

1 comments, 10 reads

Posted in Rajat Jaiswal-337252 on 12 February 2015

TSQL Tuesday #63 – Security

This months T-SQL Tuesday is hosted by none other than Kenneth Fisher (B|T). His topic for this month revolves around security and how you manage security. There probably couldn’t be a more fitting topic; especially with the many breaches we have had lately both ones that… Read more

2 comments, 104 reads

Posted in The SQL Professor on 12 February 2015

Detecting Encryption

I ran across an article recently from MSSQLTips by my friend, Brian Kelley. It talks about the ways you can detect encryption in use in your database. Brian’s approach, which is one I agree with, is that you can look for symmetric keys, asymmetric keys, and certificates in the system… Read more

2 comments, 384 reads

Posted in The Voice of the DBA on 11 February 2015

Automating SSAS Backups

Backing up databases is one of the most important jobs of a DBA. If your data is not safe, your job is not safe. Data is the lifeblood of a DBA. That said, there are so many products out on the market that will help with backing up transactional databases… Read more

0 comments, 4,712 reads

Posted in SQL Swimmer on 11 February 2015

What is Advanced Analytics?

Advanced Analytics, or Business Analytics, refers to future-oriented analysis that can be used to help drive changes and improvements in business practices.  It is made up of four phases:

Descriptive Analytics: What is generally referred to as “business intelligence”, this phase is where a lot of digital… Read more

0 comments, 159 reads

Posted in James Serra's Blog on 11 February 2015

SQLSaturday#380 NYC Event Update - Pre-cons Announced!

Welcome to SQLSaturday #380 - Precons Announced!

In addition to the extraordinary extravaganza SQLSaturday NYC event we have planned for Saturday, May 30, 2015, we are pleased to announce our awesome FULL DAY Precons, by some of our favorite MVPs and industry SQL experts!  This is a special training treat… Read more

0 comments, 4,365 reads

Posted in Pearl Knows on 11 February 2015

Security as a Fleeting Thought

Today we have another installment in what is known as TSQL Tuesday.  This month we have an invitation and topic given to us by the infamous Kenneth Fisher ( blog | twitter).

Today, the invitation is for us to share our stories on how we like to manage security.… Read more

5 comments, 4,480 reads

Posted in SQL RNNR on 10 February 2015

Excel BI Tip #20: Wingdings–an Excel Services Supported Indicator Alternative

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not… Read more

4 comments, 5,277 reads

Posted in DataOnWheels on 10 February 2015

T-SQL Tuesday #63 – Security

It’s T-SQL Tuesday time again and this month we look at security. Kenneth Fisher has chosen this as his topic for February and you can read his invite here. There are lots of choices on what you write about, and I’m looking forward to reading what people choose.

You… Read more

3 comments, 5,496 reads

Posted in The Voice of the DBA on 10 February 2015

TSQL Tuesday #63: – DBA Myths: You can’t deny something to a member of db_owner database role

So I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it would make a fun topic for this month. I’d actually written this post before I wrote my hosting post for T-SQL Tuesday but it fit so well I couldn’t bring… Read more

7 comments, 5,865 reads

Posted in SQLStudies on 10 February 2015

T-SQL Tuesday #63 - Managing Security - Enforce SQL Login Policies

Today, February 10, 2015 is TSQL Tuesday, no.63! (Click on the highlighted link for the Invitation.)  Hosted this month, by Student of SQL, aka on twitter @sqlstudent144, and maintains his SQLStudies.com blog, Kenneth Fisher. Ken asks us a very pertinent question that makes up our latest… Read more

0 comments, 6,045 reads

Posted in Pearl Knows on 10 February 2015

Managing Security – TSQL2sday # 63

A big thank you goes out to Kenneth Fisher ( b | t ) for hosting this month’s TSQL2sday party. Security is a big deal. How many times have you opened the paper (I’m dating myself, I know – no one reads an actual newspaper anymore, it’s all online now)… Read more

2 comments, 104 reads

Posted in SQL Swimmer on 10 February 2015

T-SQL Tuesday #63: How do you manage security

This month’s T-SQL Tuesday is hosted by Kenneth Fisher (blog | twitter) and its subject is about security.

Security is one of those subjects that most DBAs have to deal with regardless of specialty. So as something we all have to work with at some point or another… Read more

0 comments, 5,567 reads

Posted in Koen Verbeeck on 10 February 2015

T-SQL – Read CSV files using OpenRowSet

We can directly access a CSV file using T-SQL.

Input file

Configure server to run Ad Hoc Distributed Queries

sp_configure 'Ad Hoc Distributed Queries',1
GO
reconfigure
GO

Check for Microsoft Access Driver on your system

SQL

select 
[hour],
UserID,
[ReportLaunch]
from openrowset('MSDASQL'
,'Driver={Microsoft Access Text Driver (*.txt, *.csv)}'
,'select *…

Read more

0 comments, 7,312 reads

Posted in PowerSQL By Prashanth Jayaram on 9 February 2015

Newer posts

Older posts