|
|||||
|
|||||
|
Get Your Own BlogIf you would like to blog on SQLServerCentral.com then send an email to webmaster@sqlservercentral.com. Contact the authorAll BlogsFeedsArchives for this blog
The Voice of the DBA
Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest
Archives: December 2018Testing SQL in the Advent of CodeI like participating in the Advent of Code each year, though my participation often varies wildly as life gets in the way. Still, trying to solve some programming challenges is a good way of practicing your skills. If you’re competitive, you can try and see how quickly you can solve… Read more 0 comments, 2,079 reads Posted in The Voice of the DBA on 28 December 2018 My SQL Server Travels in 2018It’s the end of the year, and I’m looking back at the events and travels I’ve had this year. I keep a list of travels on my blog for speaking as a kind of Speaking CV, and United (my primary airline) provides me with a summary of travel each… Read more 1 comments, 258 reads Posted in The Voice of the DBA on 27 December 2018 Identity Gaps–#SQLNewBloggerAnother post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Many people think that that an identity property will ensure a consistent, increasing numerical value. I ran across this tweet that indicates that situation. This isn’t really true,… Read more 6 comments, 2,256 reads Posted in The Voice of the DBA on 26 December 2018 2018 Advent of Code–Day 1I enjoy when the Avent of Code comes around each year. I seem to make this a December (or sometimes New Year’s) resolution to get through them all, but life usually gets in the way. In any case, I decided to at least start this year and see how far… Read more 0 comments, 303 reads Posted in The Voice of the DBA on 24 December 2018 Restarting a Sequence–#SQLNewBloggerAnother post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. As part of my experiments with the sequence object, I wanted to see what allows me to restart a sequence at a new value. This is useful in… Read more 0 comments, 978 reads Posted in The Voice of the DBA on 20 December 2018 Azure at the RanchFrom our webinar today, I mentioned I had a dog named “Azure”. Here she is. No, this isn’t an homage to Microsoft, and I didn’t name the dog. My daughter did, and she’s not a data platform person. 0 comments, 332 reads Posted in The Voice of the DBA on 18 December 2018 The Data Catalog from RedgateOne of the important tasks that is needed for any organization that wants to better protect their sensitive data is some sort of list of what data is sensitive. Often we might assume all data matters, in which case we embark upon projects to over protect everything. That leads to… Read more 0 comments, 327 reads Posted in The Voice of the DBA on 17 December 2018 The Year in Review Webinar–Dec 18Join me for our Year in Review Webinar next week, Dec 18, at 4pm GMT. I’ll be joining Kendra and Grant to talk through what happened this year, and make a few predictions for 2019. It should be fun, festive, maybe a bit silly, but a good break in your… Read more 0 comments, 862 reads Posted in The Voice of the DBA on 14 December 2018 The Default Frame for Window FunctionsAnother post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This bites me constantly, and I was reminded of this while watching Kathi talk at #SQLintheCity. When you write a Window function, there is an implicit… Read more 1 comments, 855 reads Posted in The Voice of the DBA on 13 December 2018 Lessons from the Phoenix Project–Leave SlackNot @Slack, but slack time, time when you aren’t buried on a particular project. In the book, The Phoenix Project, the Brent character is the jack of all trades, the one that everyone goes to to fix and solve problems. He gets tasked with important projects and work,… Read more 0 comments, 232 reads Posted in The Voice of the DBA on 12 December 2018 T-SQL Tuesday #109–InfluenceThis month’s T-SQL Tuesday host is Jason Brimhall. He asks everyone to write about influence, which is something that I should know about and think I have, but am somewhat uncomfortable writing about. That being said, here’s my entry this month. Influencing OthersOne of the motivations behind creating… Read more 2 comments, 235 reads Posted in The Voice of the DBA on 12 December 2018 SQL Census–From the Redgate FoundryThe Foundry at Redgate Software is our version of Microsoft Research. Kind of. We tackle some projects that are interesting and might make good products at some point, but we’re looking at the in the investigative phase. You can read about the Foundry here. Some interesting work is taking… Read more 0 comments, 236 reads Posted in The Voice of the DBA on 11 December 2018 Basic Sequences–#SQLNewBloggerAnother post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I haven’t used sequences much in my work, but I ran into a question recently on how they work, so I decided to play with them a bit. Read more 2 comments, 2,451 reads Posted in The Voice of the DBA on 5 December 2018 SQL in the City is Next WeekNext Wednesday, Dec 12, I’ll be back in the UK with Kathi, Kendra, and Grant for SQL in the City Streamed. You can register today and join us for a set of DevOps talks that will get you to think about ways to better perform database development. For once I… 0 comments, 772 reads Posted in The Voice of the DBA on 4 December 2018 Updating SSMS to 17.9.1I went to download the SSMS v17.9.1 package the other day and saw this: I remember some issues with a C++ redistributable with a SQL Server install (2016?) and decided to just check on this. I really wish that these articles and items were crosslinked, so I could check them… Read more 0 comments, 890 reads Posted in The Voice of the DBA on 3 December 2018 |
Subscribe to this blog
