Interview – Benjamin Nevarez

I decided to start a series of blogs where I interview key people in the SQL Server community. Instead of me asking technical questions, I plan on asking about their outlook on the future, books they read (non-fiction and/or technical),  and their overall thoughts on where technology (mainly SQL Server) is headed. You can find more interviews here.

Next up: Benjamin Nevarez (b | t):

Benjamin Nevarez
Benjamin Nevarez

Mohammad: Where do you see SQL Server technology evolving to 5 years from now? More cloud focused?

Benjamin: Well, I really don’t see many big changes in five years, it is a very short time. As an example we can look back a few years ago when SQL Server in-memory technologies like Hekaton and columnstore indexes were originally released. We were very excited about these technologies but later realized that they were initially released with serious limitations leaving us to wait for them to mature and become widely adopted. So I hope a wide adoption of these technologies, especially Hekaton, in the next few years. Continue reading “Interview – Benjamin Nevarez”

Interview – Mindy Curnutt

I decided to start a series of blogs where I interview key people in the SQL Server community. Instead of me asking technical questions, I plan on asking about their outlook on the future, books they read (non-fiction and/or technical),  and their overall thoughts on where technology (mainly SQL Server) is headed. You can find more interviews here.

Next up: Mindy Curnutt (b | t):

Mindy Curnutt
Mindy Curnutt

Mohammad: Where do you see SQL Server technology evolving to 5 years from now? More cloud focused?

Mindy: While a lot has changed in the Microsoft Data Platform in the last 5 years, the customers I work with have not changed nearly as quickly, and I really don’t see that pattern changing much over the NEXT 5 years. To be clear, I work mostly with the transportation and logistics industry Continue reading “Interview – Mindy Curnutt”

Interview – Allan Hirt

I decided to start a series of blogs where I interview key people in the SQL Server community. Instead of me asking technical questions, I plan on asking about their outlook on the future, books they read (non-fiction and/or technical),  and their overall thoughts on where technology (mainly SQL Server) is headed. You can find more interviews here.

Next up: Allan Hirt (b | t):

Allan Hirt
Allan Hirt

Mohammad: Where do you see SQL Server technology evolving to 5 years from now? More cloud focused?

Allan: I dislike the word “cloud” on its own, similar to how I feel about inaccurately using the word “cluster.” Are we talking about the WSFC or Pacemaker? An FCI? An AG? All of it? Something else? Continue reading “Interview – Allan Hirt”

Interview – Erin Stellato

I decided to start a series of blogs where I interview key people in the SQL Server community. Instead of me asking technical questions, I plan on asking about their outlook on the future, books they read (non-fiction and/or technical),  and their overall thoughts on where technology (mainly SQL Server) is headed. You can find more interviews here.

Erin Stellato
Erin Stellato

Next up: Erin Stellao (b | t):

Mohammad: Where do you see SQL Server technology evolving to 5 years from now? More cloud focused?

Erin: Let me state that I don’t think 5 years ahead in my own life, so trying to predict changes in technology really isn’t in my comfort zone. That said, it’s 2017 and there are still a large number of companies running SQL Server 2008 and 2008R2 in production. Therefore, in 2022 I think that companies will still be running SQL Server 2014 and maybe even SQL Server 2012. I expect there will still be a box version of SQL Server that’s current, and people will still be migrating to the cloud. Will there be more solutions in the cloud, compared to on site? That might be too close to call. Continue reading “Interview – Erin Stellato”

Interview – Pinal Dave

I decided to start a series of blogs where I interview key people in the SQL Server community. Instead of me asking technical questions, I plan on asking about their outlook on the future, books they read (non-fiction and/or technical),  and their overall thoughts on where technology (mainly SQL Server) is headed. You can find more interviews here.

Next up: Pinal Dave (b | t):

Pinal Dave
Pinal Dave

Mohammad: Where do you see SQL Server technology evolving to 5 years from now? More cloud focused?

Pinal: This is a great question. I personally believe just like any other technology, in premise hosting of SQL Server will remain in place as much as the cloud adoption will grow. I do not see cloud technology replacing in-premises installation in the next 5 years. As a SQL Server Performance Tuning Consultant, I get the opportunity to work with lots of different organizations and I noticed that quite a lot of people still using the old technology as SQL Server 2000 and SQL Server 2005. They are willing to pay a very high amount to tune their server to run faster, rather than migrating to newer versions. May be after 10 years or so we will see strong shift and focus on the cloud. Continue reading “Interview – Pinal Dave”

Interview – Aaron Bertrand

I decided to start a series of blogs where I interview key people in the SQL Server community. Instead of me asking technical questions, I plan on asking about their outlook on the future, books they read (non-fiction and/or technical),  and their overall thoughts on where technology (mainly SQL Server) is headed. You can find more interviews here.

Next up: Aaron Bertrand (b | t):

Aaron Bertrand
Aaron Bertrand

Mohammad: Where do you see SQL Server technology evolving to 5 years from now? More cloud focused?

Aaron: I think you will see more cloud adoption. Customers will get over some of their fears and apprehension, and the cloud service providers will find the “sweet spots” for different types of workloads and applications. However, there will always be customers that won’t trust “someone else’s computer,” or can’t – due to various industry or governmental regulations. Aside from cloud, I think with the evolution of SQL Server on Linux and Visual Studio on Mac, we’re seeing a more imaginative Microsoft that might have a few surprises for us yet. Continue reading “Interview – Aaron Bertrand”

Interview – Paul Randal

I decided to start a series of blogs where I interview key people in the SQL Server community. Instead of me asking technical questions, I plan on asking about their outlook on the future, books they read (non-fiction and/or technical),  and their overall thoughts on where technology (mainly SQL Server) is headed. You can find more interviews here.

Next up: Paul Randal (b | t):

Paul Randal
Paul Randal

Mohammad: Where do you see SQL Server technology evolving to 5 years from now? More cloud focused?

Paul: I definitely think that cloud is going to become much more prevalent as a platform and the pace of moment into the cloud will increase. I also hope to see more progress on the ability to work with databases in the 10s to 100s of terabytes – loading, querying, visualizing, and of course HA/DR solutions and backups. I don’t think the SQL Server team can abnegate their responsibility to improve things here – whether that’s in the cloud or the on-premises product. Continue reading “Interview – Paul Randal”

Book Review – “High Performance SQL Server” by Benjamin Nevarez

There is something about high performance tuning that I find very fascinating. Performance tuning your database server is one of those things that you cannot just pinpoint to a single cause. You must have an overall understanding of how SQL Server internals work to really understand all the areas that you can “tune”, how they all interplay with each other, etc. Without having a grasp on this crucial subject, you will find yourself scratching your head more times than not when learning performance tuning. Continue reading “Book Review – “High Performance SQL Server” by Benjamin Nevarez”

Interview – Kendra Little

I decided to start a series of blogs where I interview key people in the SQL Server community. Instead of me asking technical questions, I plan on asking about their outlook on the future, books they read (non-fiction and/or technical),  and their overall thoughts on where technology (mainly SQL Server) is headed. You can find more interviews here.

Next up: Kendra Little (b | t):

Kendra Little
Kendra Little

Mohammad: Where do you see SQL Server technology evolving to 5 years from now? More cloud focused?

Kendra: Over five years time, I think we will see a “normalizing” of many of the more recent advancements we’ve had in the technology. So yes, I think there will be more people using the cloud as those features continue to mature. Continue reading “Interview – Kendra Little”

Interview – Adam Machanic

I decided to start a series of blogs where I interview key people in the SQL Server community. Instead of me asking technical questions, I plan on asking about their outlook on the future, books they read (non-fiction and/or technical),  and their overall thoughts on where technology (mainly SQL Server) is headed. You can find more interviews here.

Next up: Adam Machanic (b | t):

Adam Machanic
Adam Machanic

Mohammad: Where do you see SQL Server technology evolving to 5 years from now? More cloud focused?

Adam: Over the next five years there will definitely be a continued push toward the cloud. And this only makes sense; competition will continue to drive down pricing (albeit slowly), and for most companies, at some point it will simply become fiscally unwise to continue with the cycle of managing and replacing a large amount of in-house hardware. Continue reading “Interview – Adam Machanic”

Interview – Chrissy LeMaire

I decided to start a series of blogs where I interview key people in the SQL Server community. Instead of me asking technical questions, I plan on asking about their outlook on the future, books they read (non-fiction and/or technical),  and their overall thoughts on where technology (mainly SQL Server) is headed. You can find more interviews here.

Next up: Chrissy LeMaire (b | t):

Chrissy LeMaire
Chrissy LeMaire

Mohammad: Where do you see SQL Server technology evolving to 5 years from now? More cloud focused?

Chrissy: I’m the opposite of a visionary and really have no idea. That being said, five years doesn’t seem very long; I think it’ll take closer to 10 years for to fully realize the cloud thing. Microsoft may be cloud-focused, but the industries I work in are still very on-premises when it comes to Microsoft software. Continue reading “Interview – Chrissy LeMaire”

Interview – Tim Radney

I decided to start a series of blogs where I interview key people in the SQL Server community. Instead of me asking technical questions, I plan on asking about their outlook on the future, books they read (non-fiction and/or technical),  and their overall thoughts on where technology (mainly SQL Server) is headed. You can find more interviews here.

Next up: Tim Radney (b | t):

Tim Radney
Tim Radney

Mohammad: Where do you see SQL Server technology evolving to 5 years from now? More cloud focused?

Tim: I see the cloud focus still ongoing. Within 5 years, I see more small to mid-size companies embracing Cloud rather than building out their own large datacenters. Analytics will continue to be a strong focus as companies need to trend their data. Continue reading “Interview – Tim Radney”

Interview – Brent Ozar

I decided to start a series of blogs where I interview key people in the SQL Server community. Instead of me asking technical questions, I plan on asking about their outlook on the future, books they read (non-fiction and/or technical),  and their overall thoughts on where technology (mainly SQL Server) is headed.

First up: Brent Ozar (b | t):

Brent Ozar interviewed by Mohammad Darab
Brent Ozar

Mohammad: Where do you see SQL Server technology evolving to 5 years from now? More cloud focused?

Brent: Today, in early 2017, https://www.spotlightessentials.com/world/sql-server shows that the majority of shops are still on SQL 2008/2008R2. Continue reading “Interview – Brent Ozar”

Google Wifi Review

Wifi routers have always been a pain in the butt for me. I live in a 3-level townhouse and it’s always been a challenge to evenly distribute the internet across all three floors. Over the past 10-15 years, I’ve tried multiple routers. From name brands like the old Linksys WRT54G router and Apple Airport Extreme, to the lesser known Almond+ by Securifi. The Almond+ was actually great when compared to the rest. The setup and wifi reception was great. The only downside was the router was on the third floor, so the internet speed in the basement was horrible. I started to do more research on how to evenly distribute the wifi and came across products like eero, and Google WifiThese products offer a “3 pack” of routers that work together to give you evenly distributed internet reception. Continue reading “Google Wifi Review”

Stuff and Replace Function in SQL Server : Detailed Description

(This is a guest blog post by Daniel Jones (li | t | fb). Daniel is a SQL Server DBA and contributor at SQL Tech Tips. Having 2 + years of experience in SQL recovery and system infrastructure.)

In SQL Server, STUFF and REPLACE functions are used to replace the characters in a string. Both functions play an important role in Transact-SQL with performing the distinct functionality. In the following section, we are going to discuss about Stuff and Replace function in detail. Continue reading “Stuff and Replace Function in SQL Server : Detailed Description”

Error 3241 in SQL Server

(This is a guest blog post by Daniel Jones (li | t | fb). Daniel is a SQL Server DBA and contributor at SQL Tech Tips. Having 2 + years of experience in SQL recovery and system infrastructure.)

Microsoft SQL Server Backup Error Code 3241 Restore Headeronly

Sometimes, the users of MS SQL server faced an error when they try to restore SQL database from the backup file in the SQL server. This error is known as SQL server error 3241 and it generates the below-mentioned error message.

Error 3241 SQL Server

Due to this error message, the users cannot restore the data from the backup file into SQL Server database. Therefore, in this post, we are going to discuss the reason for the occurrence of error 3241 and the relevant solutions to resolve the error. Continue reading “Error 3241 in SQL Server”

How To Study Smarter Not Harder

How To Study Smarter Not Harder

One of my “New Year resolutions” is to increase my knowledge. As an IT professional, it is crucial to stay abreast with the constant changes in technology. The new replaces the old and by the time you get around to learning the new, that becomes old. As someone who works closely with SQL Server, I find it extraordinarily cumbersome to stay abreast of the new trends and technologies. Just SQL Serve 2016 alone has so many cool new features. Imagine the constant updates with Microsoft Azure. All that can be demotivating. Continue reading “How To Study Smarter Not Harder”

How To Decrypt Stored Procedure In SQL Server

I recently had to view the code behind a couple stored procedures in SQL Server. Usually that’s a very simple thing to do. Just right click the stored procedure, click Modify OR script-as “Create New” and it spits the entire stored procedure in a query window. Unfortunately for me, the stored procedures were encrypted so the usual method mentioned above did not work. Continue reading “How To Decrypt Stored Procedure In SQL Server”