End of year planning: T-SQL Tuesday #157
SQL Studies
by Kenneth Fisher
1M ago
It’s T-SQL Tuesday again! And Garry Bargsley (blog|twitter) has asked us what we have planned for the end of the year? This is another somewhat difficult one for me to answer, I did just start a new job remember? So instead let’s talk about one thing I’ve seen done that always impresses me. Planning. Of course this assumes that you have the time for proactive behavior not just reactive, but if you’ve got the time it can be quite helpful. Spend a couple of days thinking about all of the things that are wrong with your system, no matter how large and time-consuming or small and petty. If you ha ..read more
Visit website
End of year planning: T-SQL Tuesday #157
SQL Studies
by Kenneth Fisher
1M ago
It’s T-SQL Tuesday again! And Garry Bargsley (blog|twitter) has asked us what we have planned for the end of the year? This is another somewhat difficult one for me to answer, I did just start a new job remember? So instead let’s talk about one thing I’ve seen done that always impresses me. Planning. Of course this assumes that you have the time for proactive behavior not just reactive, but if you’ve got the time it can be quite helpful. Spend a couple of days thinking about all of the things that are wrong with your system, no matter how large and time-consuming or small and petty. If you ha ..read more
Visit website
#PowershellBasics: Warnings and how to hide them.
SQL Studies
by Kenneth Fisher
1M ago
One of my favorite parts of having a new job is that I learn a ton. (No really, my brain feels like there is a ton of information just sitting on it and compressing it into a little brain shaped ball.) Right now I’m doing a lot of Powershell and since Powershell is fairly new to me I’m learning quite a bit. Today I was working with Get-AzSqlInstance (used to get a list of Managed Instances). As it turns out there is a breaking change coming up and Microsoft has been kind enough to warn me about it every time I run it. WARNING: Upcoming breaking changes in the cmdlet ‘Get-AzSqlInstance’ : The ..read more
Visit website
What’s next: Job search burnout
SQL Studies
by Kenneth Fisher
1M ago
I was given 4.5 months notice this past June and was fortunate to find a new job. I blogged about my job search and the lessons I learned along the way (update 2, update 3, update 4) but unsurprisingly I still have more to say! A few months in I was discussing my job search with some friends and commented that burnout is very possible with a job search. In fact, I’d say it’s very probable if your search drags on even a little bit. I’ve always said that finding a job is a job in and of itself and it’s one with some special extra stresses. In this case, I was not only spending time looking for a ..read more
Visit website
SQL Homework – December 2022 – What’s new in SQL Server?
SQL Studies
by Kenneth Fisher
1M ago
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I need SQL Server to stay popular for at least another decade or two. One of the things that I’ve found the most useful over the years is that I’m at least familiar with the majority of what’s available within the areas of SQL that I work in. Can I use them without having to look anything up? No, not in a lot of cases. Do I at least know they exist? Yes. One thing that’s helped me (aside from following a bunch of SQL experts and reading their blogs) is reading over the list of things ..read more
Visit website
#PowershellBasics: Warnings and how to hide them.
SQL Studies
by Kenneth Fisher
2M ago
One of my favorite parts of having a new job is that I learn a ton. (No really, my brain feels like there is a ton of information just sitting on it and compressing it into a little brain shaped ball.) Right now I’m doing a lot of Powershell and since Powershell is fairly new to me I’m learning quite a bit. Today I was working with Get-AzSqlInstance (used to get a list of Managed Instances). As it turns out there is a breaking change coming up and Microsoft has been kind enough to warn me about it every time I run it. WARNING: Upcoming breaking changes in the cmdlet ‘Get-AzSqlInstance’ : The ..read more
Visit website
What’s next: Job search burnout
SQL Studies
by Kenneth Fisher
2M ago
I was given 4.5 months notice this past June and was fortunate to find a new job. I blogged about my job search and the lessons I learned along the way (update 2, update 3, update 4) but unsurprisingly I still have more to say! A few months in I was discussing my job search with some friends and commented that burnout is very possible with a job search. In fact, I’d say it’s very probable if your search drags on even a little bit. I’ve always said that finding a job is a job in and of itself and it’s one with some special extra stresses. In this case, I was not only spending time looking for a ..read more
Visit website
SQL Homework – December 2022 – What’s new in SQL Server?
SQL Studies
by Kenneth Fisher
2M ago
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I need SQL Server to stay popular for at least another decade or two. One of the things that I’ve found the most useful over the years is that I’m at least familiar with the majority of what’s available within the areas of SQL that I work in. Can I use them without having to look anything up? No, not in a lot of cases. Do I at least know they exist? Yes. One thing that’s helped me (aside from following a bunch of SQL experts and reading their blogs) is reading over the list of things ..read more
Visit website
Setting up my new workstation with some Chocolatey goodness.
SQL Studies
by Kenneth Fisher
3M ago
As you might be aware I started a new job last week. Which means a new workstation and installing lots of tools. My new lead suggested that I try out a program called Chocolatey. Chocolatey is a software management solution that you can use through Powershell. Installing it on my workstation was pretty simple and took me something like 5 minutes. From there I installed Powershell Core, DbaTools, SQL Server Management Studio, and Azure Data Studio in 4 simple commands. The –yes just means that I don’t want to have to deal with prompts and just plan on accepting them all. choco install powers ..read more
Visit website
What is production grade code? : T-SQL Tuesday #156
SQL Studies
by Kenneth Fisher
3M ago
It’s that time of the month again! It’s T-SQL Tuesday and this month Tom Zika (blog|twitter) is hosting. Tom would like us to talk about What makes code production grade? One of the things that I love most about being a DBA is how often the answer is it depends. (Pro-tip: Never say it depends without talking about why it depends.) Production grade could mean how robust the code is (how often will it fail and what happens if it does), how well it performs (it’s all well and good if the code blazes when you’re dealing with 10 rows but how about 10 million?), and how easy is it to maintain? (Yes ..read more
Visit website

Follow SQL Studies on Feedspot

Continue with Google
OR