This is a series of posts on the PASS Summit and SQL Saturdays. I’m outlining some thoughts here, sometimes for the first time, but on topics that I think make better events. These are opinions and thoughts, not mandates or demands.
Latest Blog Posts
Please join me and about 4000+ other technology professionals for the annual PASS Summit in Seattle, WA October 24th – 28th. But before I talk about this year’s event, join me in a trip down memory lane about my path to the PASS Summit. If not, skip to the…
I’ve had an aging desktop for some time. I originally bought it from Glenn Berry (b | t), who I think gets a new machine every quarter or two. Seriously, I think there is a computer in every room of his house, and he has a lot of rooms.
In… Read more
No Sessions For You! The announcements of the speakers and sessions selected for the PASS Summit 2016 were recently announced, and I was not picked for any sessions. I do not have any ill feelings to those that go through the herculean effort to create the reviews and the Summit…
Overview of the Situation
While accessing data files in SQL Server, many issues may occur that may lead to frustrating situation for users. One such situation occurs when user are running DBCC SHRINKFILE. There are many issues with running DBCC SHRINKFILE on your SQL Server data file. In the information… Read more
0 comments, 86 reads
Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 24 June 2016
Security is a vital component of data security. In today’s day and age it is imperative to think about security. Recently there have been many high profile examples of data theft. This is a very simple script which allows you to find any SQL Server authenticated accounts that have either… Read more
I was recently doing some work on my Windows 10 desktop and placed a drive on one of the slower internal disks. It’s old. It’s 7200 RPM. It’s just plain slow. All that’s fine and good as I’m not doing any production workloads from this development machine.
I thought that… Read more
It’s been a while since my last post, there are various reasons for my absence: work, illness, having our house rewired, etc., but one of the biggest reasons is my struggle with how a few folks in the SQL community treat the PASS organization and those that volunteer their time… Read more
I was going through some really old blogging ideas and I stumbled over this one and seeing as I love finding creative solutions in XQuery, I’m not sure why I hadn’t got this down into a blog post earlier!
Imagine the following contrived xml snippet which is essentially just a… Read more
I love Azure and I love PowerShell. They are a perfect marriage. It’s amazing how much automation you can do inside of Azure with some PowerShell scripting. In fact, you hardly see me using the Azure Portal these days.
Automation is great until manual processes are required. I have been… Read more
Another Twitter-born blog post! I love getting new ideas from the community. Real world ideas for solving real world problems!
The original question was “Does SQL Compare or others prods allow me to compare 1 “gold” db to the 57 “identical” databases in prod at once? asking for a… Read more
The pricing for Azure SQL Data Warehouse (SQL DW) consists of a compute charge and a storage charge. For compute, it is not based on hardware configuration but rather by data warehouse units (DWU). DWU can be scaled up or down via a sliding bar in just a… Read more
I’m excited to announce that I have been selected to speak at PASS Summit again this year! I’ll be presenting a new session, “Extending Applications Securely Using Service Broker”:
If you’ve ever tried to build a distributed application – one that spans multiple servers or even multiple sites – you…
I’ve had a lot of luck in my career, especially as it pertains to my work environment. Although I can’t say every technical job I’ve had was all unicorns and bacon, I’ve been very fortunate to have been treated fairly and professionally through most of my employment history. Not only… Read more
I presented at our local Melbourne SQL Server User Group (SSUG) this week on Azure Cortana Intelligence Suite – and the integration with the Azure Data Catalog. If you are interested to see the presentation then have a look here – https://mrfoxsql.wordpress.com/presentations/
One of the things which stood out… Read more
Today PASS released a bunch of stuff for the upcoming election including the attributes of an “ideal candidate”. We put in quite a bit of time on that description, in part because people often ask “am I ready” and in part because it is the next step in doing a… Read more
Can you guess what all of these people have in common?
- Shawn Weisfeld
- Joe Healy
- Barry Ralston
- Trey Johnson
- Jon Winer
- Wes Dumey
- Donnie Reynolds
- Kevin Jacobs
- Joseph Memmo
- Brian Knight
- Michael Antonovich
- Declan Link
- Patrick Thompson
- Jeff Garbus
- Jim Blizzard
- Ken Tucker
- Jessica Moss
- Bayer White
- Joe Celko
We’ve advanced the closing date for the SQLSaturday Orlando call for speakers to July 17. That’s to give us time to set the schedule and have it announced around August 1, just a little more than 60 days before the event. We’ll get an email with that information out to… Read more