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

Latest Blog Posts

Grant’s Fly-by-night Leadership Course – The Plan

  1. Get a better name
  2. Define my personal goals for the course

I won’t be sharing these with you. I may share them with my Inner Circle (defined below). I’m thinking this is a 2-3 year commitment I’m making. I need to have my own set of measurements to ensure that… Read more

6 comments, 134 reads

Posted in The Scary DBA on 28 July 2015

SSC Editorial: Would You Pay to Wear Jeans at Work?

Would You Pay to Wear Jeans at Work turned out to be popular piece when posted a couple weeks back. The premise is that some companies allow a relaxed dress code in return for a donation to a specified charity.  I’ve opted in at times and not at others to… Read more

0 comments, 138 reads

Posted in SQLAndy on 28 July 2015

Database Stuck in Single-User Mode Due to Botched Restore

Working in a development environment, I botched up a restore. After this restore attempt to overwrite my database with the previous version, I had it stuck in single-user mode.

SSMS provided me with helpful messages such as this:

Changes to the state or options of database 'PoorDb' cannot be made… Read more

0 comments, 102 reads

Posted in SQL Barbarian on 28 July 2015

When Emotional Intelligence Trumps Math

I have been in Corporate IT long enough to know that when a bad decision is made, you move out of the way of that train while quietly doing what you can to mitigate the inevitable wreck that is ahead…

(read the rest on LinkedIn, here)


Read more

0 comments, 105 reads

Posted in @chuckboycejr on 28 July 2015

Creative Schools by Sir Ken Robinson

Education. The key topics for everyone. In his incredibly famous TED Talk “Do Schools Kill Creativity“, which might be some of the most important 20 minutes that you will spend this year, Sir Ken Robinson argued about the current state…

Read more

0 comments, 113 reads

Posted in Niko's blog on 28 July 2015

Present at SQL Saturday #386 – Achievement Unlocked!


SQL Saturday #386 (Albany, NY) – My first SQL Saturday Session


So that picture to the right is me out front of the SUNY Albany campus around 6:45 AM. It was a nice cool morning and I decided to start my day with a nice 5k run around the campus.… Read more

0 comments, 89 reads

Posted in cjsommer.com on 28 July 2015

SQL Server Audit: Getting Started

SQL Server has the ability to monitor both server and database level events via the SQL Server Audit feature.  Audited events can be written to the server application or security logs, or to a file where you specify the location (the most secure route).   SQL Server Audit is easy to… Read more

0 comments, 120 reads

Posted in Adam Kreul | Blog on 28 July 2015

What’s the Size of that Index?

I have previously written about finding what the big space consumers are within the database. I even shared scripts in those articles on how to find those big consumers (read all about it here).

That is grand when it comes to quickly finding which objects happen to be… Read more

0 comments, 112 reads

Posted in SQL RNNR on 27 July 2015

Culture Differences: US v UK

This is a bit of an off topic post from the technical stuff, but there’s a bit of a tie-in, so stick with me.

I had to get a tire fixed this morning. I actually owned a replacement tire, so I just needed someone to mount it on the existing… Read more

0 comments, 169 reads

Posted in The Voice of the DBA on 27 July 2015

SQLSaturday #423 Baton Rouge

This is I believe the 7th SQLSaturday in Baton Rouge. Please come out this Saturday at the LSU Business Center to enjoy free training, prizes and networking with over 500 IT professionals.

 

Here is the schedule.

Read more

0 comments, 74 reads

Posted in The Smiling DBA on 27 July 2015

Sneak Preview – Episode 014 - WaterOx Consulting

Reading Time: 1 minutes

Let’s Play A Game! So, just to tickle your fancy, here is...

The post Sneak Preview – Episode 014 appeared first on WaterOx Consulting.

Read more

0 comments, 134 reads

Posted in WaterOx SQL on 27 July 2015

Baltimore Crime Report Using Power BI

As part of my quest for using data to find answers to everyday questions using Power BI – after analyzing baby names and eating habits – I turned to crime data for the city of Baltimore.

Data is obtained from Open Baltimore and I used Power BI Desktop. Once you… Read more

0 comments, 115 reads

Posted in Sam Vanga on 27 July 2015

Permissions Posters

I’ve been doing a lot of research recently for my permissions session and for a project at work. During said research I came across three great sets of posters about permissions. I’m going to list them here and on my Study and Reference Materials

Permissions Hierarchy (Database Engine)

Database Engine… Read more

2 comments, 113 reads

Posted in SQLStudies on 27 July 2015

Indexes on GUIDs – Not Only Fragmentation

A client called us with the following issue:

He had a table of a few dozen million rows. The table had a few GUID columns that had to be indexed.

He had an ETL process that inserted a few thousand rows every few minutes. When the table had only a… Read more

3 comments, 186 reads

Posted in Matan Yungman on 27 July 2015

Single value filters and custom error messages in Power BI

"Let me be the one for you, otherwise we need to work on communication". Basically this was a very brief description of a recent use case for a power view report which had been later replicated in a Power BI slide as well.

Users were aware of PowerView / Power…

Read more

0 comments, 110 reads

Posted in Data Adventures on 27 July 2015

SQL Server 2016 Blogs

Hi friends, As you all know that SQL Server CTP2 has released with new great features. Here is the list of …

Continue reading Read more

0 comments, 165 reads

Posted in Kapil Blogs on 26 July 2015

Community Reactions to Power BI General Availability

Power BI is released to the public on Friday, 07/24. There’re both free and Pro versions. For full details about products, downloads, and pricing, go to https://powerbi.microsoft.com/.  This is how the community reacted to the release on Twitter.

An exciting news was announced a day prior to GA. The… Read more

0 comments, 123 reads

Posted in Sam Vanga on 26 July 2015

Transparent Data Encryption in Azure SQL Database

Transparent Data Encryption in Azure SQL Database
JULY 26, 2015

Introduction
Transparent Data Encryption (TDE) is a security feature of SQL Server that has been around since SQL Server 2008. With TDE, the entire database is encrypted (also called "at-rest" encryption). With a non-TDE database, if someone were to steal…

Read more

0 comments, 165 reads

Posted in Pie in the Sky on 26 July 2015

A simple way for consistency TIP #106

 

Whenever we develop application of maintain application we define sets of rules or policies  like naming convention , data type, database & SQL SERVER properties (like which property should be unable or disable)  but the problem is to cross check or to enforce these properties is very tedious.

To… Read more

0 comments, 79 reads

Posted in Rajat Jaiswal-337252 on 26 July 2015

Security-Fixes for SQL Server and why Security Best Practices Matter / Sicherheitsfixe für SQL Server und warum Sicherheits Best Practices wichtig sind (MS15-058 SQL Server Security Bulletin)

Ziemlich genau ein Jahr nachdem die für 5 Jahre ersten Sicherheits-Bugs in SQL Server gefixt werden mussten, gibt es nun, seit 14.7.2015, wieder einen Grund, seine Security-Patching-Policy zu testen.

- Wenn man denn eine solche für SQL Server hat.

Und damit möchte ich jetzt niemanden anprangern. Denn: die letzten Jahre… Read more

Newer posts

Older posts