Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

How to Recover Data From Corrupted Log File In SQL Server ?

Introduction

SQL Server is a database platform designed for providing large-scale transactions, e-commerce applications, data mining, etc. It is widely used on Business platforms for data analysis, data integration and processing components.

Structured Query Language (commonly known as SQL) is a programming language used for managing data held in relational… Read more

PASS 2016 – A Business Case for Attendance

For those tech professionals who play in the SQL Server and Business Intelligence world (and let me say that’s a huge number!) the PASS Summit provides one of the most fantastic and focused learning and networking experiences available.

I simply cannot think of any other SQL/BI event that… Read more

0 comments, 675 reads

Posted in Mr. Fox SQL on 25 April 2016

Cumulative Updates Every 2 Months

The SQL Server team is implementing an Incremental Servicing Model (ISM) to deliver updates for SQL Server. This is basically a fancy way of saying: Cumulative Updates (CUs) will no longer be shipped when the team feel it’s required, instead a new CU will ship every 2 months.

This scheduled… Read more

0 comments, 126 reads

Posted in The Database Avenger on 25 April 2016

Explicitly using tempdb with ##tables

I had someone ask me last night if this statement would create a permanent table in tempdb with a strange name or a global temp table:

CREATE TABLE tempdb..##mytable
( id int
);

My suspicion was that this would always be a temp table, but since I usually don’t include… Read more

3 comments, 708 reads

Posted in The Voice of the DBA on 25 April 2016

Monday Morning SQL Break – April 25, 2016

It’s Monday and if getting a start on the week is as exciting for you as it is for me, it’s time to take a quick break.  For the break, here’s a summary of the most popular links and content that I shared out in the past week through this… Read more

0 comments, 141 reads

Posted in StrateSQL on 25 April 2016

Get your SQL Server MCSA without taking the BI exam.

I’m a big fan of certifications as a training exercise. However not everyone has the same interests. With the new MCSA (well new 6-8 years ago) we were required to take the data exam (70-461), the admin exam (70-462) AND the BI exam (70-463). I know a number… Read more

2 comments, 723 reads

Posted in SQLStudies on 25 April 2016

Partition to Filegroup Mapping in SQL Server

Suppose you have a partition function and a corresponding partition scheme in SQL Server. The partition scheme maps each partition to a filegroup. It also indicates the next used filegroup if one was specified. Sometimes it is useful to know which partition maps to which filegroup as well as which… Read more

0 comments, 662 reads

Posted in Guy Glantser on 25 April 2016

Speaking at SQLSaturday Pensacola

I’m proud to announce that I will be speaking at SQLSaturday Pensacola on June 4th 2016! This will be my second SQLSaturday event and I’m really excited that I get to do it as a speaker. I look forward to seeing you there!

If you don’t know what SQL Saturday… Read more

0 comments, 126 reads

Posted in Anthony Nocentino's Blog on 23 April 2016

SQLSaturday Atlanta #521 May 19th & 20th 2016

SQLSaturday events are a pleasure to be a part of whether it involves speaking or volunteering. Volunteering definitely takes more work and time, but to see someone who is interested in SQL Server as a career take time to learn on a Saturday, makes it all worth the effort. When… Read more

0 comments, 130 reads

Posted in The Smiling DBA on 23 April 2016

Upcoming Webinars

Next week I am participating in two exciting webinars that I want to share with you!

Improve App Uptime: Tips from MVP David Klee + Customer Case Study with ScaleArc
April 26 – 2:00 PM to 3:00 PM Eastern

Application availability is an “across the stack” problem – straddling the… Read more

0 comments, 133 reads

Posted in Technobabble by Klee from @kleegeek on 22 April 2016

Changing the sa Password with SQLCMD

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

I wanted to make a quick note on changing the sa password, as this is a sensitive account, and the password should be changed if you ever… Read more

0 comments, 193 reads

Posted in The Voice of the DBA on 22 April 2016

Azure SQL Database pricing

Pricing Azure SQL database is difficult because various database service tier options such as database transaction units (DTU’s), max database size, disaster recovery options, and backup retention days are used to determine pricing instead of hardware (CPU/RAM/HD).  Generally I recommend starting out with a low service tier and scaling as… Read more

1 comments, 719 reads

Posted in James Serra's Blog on 22 April 2016

Where Is My Primary Replica Again?

We have many clients with multi-node Availability Groups - that is, AGs with more than two replicas.  One of the problems I have always had with Availability Group management via the GUI (admit it, you use the GUI sometimes all you non-PowerShell geeks) is the fact that most of the…

Read more

0 comments, 666 reads

Posted in Nebraska SQL from @DBA_ANDY on 22 April 2016

Power BI Service error: “This visual has unrecognized fields”

Recently I stumbled across a quite annoying error in the Power BI service. I uploaded two working reports from Power BI Desktop to the cloud service. Each report connects to its own cube and both cubes are in the same SSAS MD database. On the server, I have a gateway… Read more

0 comments, 134 reads

Posted in Koen Verbeeck on 22 April 2016

Setting up powershell remote sessions

Hey guys, differing from usual this is a quick post on setting up powershell remote sessions. I know you can remotely connect to powershell sessions using the Server Manager that comes with Windows Remote Administration Tools but it’s a bit of a clicky process and I like to eliminate using… Read more

0 comments, 145 reads

Posted in The DBA Who Came In From The Cold on 22 April 2016

How Two PASS Chapters Join Forces to Run One SQLSaturday In Orlando

We’re lucky enough to have two PASS chapters here in Orlando, oPASS and MagicPASS. Both in Orlando, but about 40 miles apart, Orlando being the metro sprawl area that it is. Back when we nervously made the decision to launch MagicPASS we also talked through the implications for SQLSaturday and… Read more

0 comments, 140 reads

Posted in SQLAndy on 21 April 2016

Columnstore Indexes: Finally Awesome in SQL 2016

Columnstore indexes are amazing for optimizing the performance of large rowcount queries that would otherwise look like a SCAN operation in an execution plan. Introduced in SQL Server 2012, they render the table read-only, however, and needed to be dropped (not even disabled) in order to insert/update/delete rows.

If you…

Read more

0 comments, 143 reads

Posted in SQL Tact on 21 April 2016

Broken Left Join

Here is a simple example of a LEFT JOIN that returns the sales stats for all employees under 21.

SELECT e.Name, COUNT(s.SaleId) AS Sales, MAX(s.DateOfSale) AS LatestSale

FROM Employees e
LEFT JOIN Sales s ON e.EmployeeId = s.EmployeeId

WHERE e.Age < 21

GROUP BY e.Name

This will return all employees… Read more

2 comments, 137 reads

Posted in The Database Avenger on 21 April 2016

Promotions and Conflicts of Interest

I noticed my co-worker, friend, and PASS board member, Grant Fritchey, posted a note on members of the PASS Board of Directors (BoD) presenting pre-cons at SQL Saturday events. It’s potentially a legal issue, and conflict of interest. I’m glad that the issue is being raised, and discussed publically. Here’s… Read more

4 comments, 186 reads

Posted in The Voice of the DBA on 21 April 2016

Newer posts

Older posts