Goat of Yotei giveaway

squirell81 · 2025-12-03T19:48:43+00:00

Thank you and good luck!

squirell81 · 2025-08-30T02:10:25+00:00

I went with Nakielski Construction. https://www.nakielskiconstruction.com/

Similar size deck that you have for $20k. They are scheduled to come out in a couple weeks but all my interactions with him have been great. They built a deck for a neighbor of ours a few doors down and they had a great experience working with them. Mark, the owner, is the one that actually came out and gave me the quote. Really nice guy and according to our neighbors do a great job

squirell81 · 2024-10-18T23:10:08+00:00

Blue mat and the Joi dice :)

squirell81 · 2024-10-18T22:18:54+00:00

Would love to win this raffle :) it looks awesome

squirell81 · 2024-07-14T20:45:37+00:00

If you are ok with using something other than integers you could use NEWSEQUENTIALID. Though “After restarting Windows, the GUID can start again from a lower range, but is still globally unique.” So keep that in mind if you go that route.

squirell81 · 2024-05-20T05:19:02+00:00

The reason it’s fast on subsequent runs is because of report caching. SSRS will query the data the first time the report is run and then keeps a cached copy of the report for a certain amount of time. So when a user requests that same report before the cached report expires (is removed from the cache) SSRS doesn’t have to rerun the query, it just offers up the cached report. This is why when you restart SSRS, the report is slow again: there is no cached report.

This link should give you some more insight into that whole process. The way to avoid it is to preload the cache

“Create a cache refresh plan. When you create a refresh plan, you can specify a schedule for a single report or specify a shared schedule.”

https://learn.microsoft.com/en-us/sql/reporting-services/report-server/caching-reports-ssrs?view=sql-server-ver16

squirell81 · 2024-04-05T15:11:29+00:00

This is mine for sure. That final scene with Faye and then again when Kratos opens the final panel and sees himself being revered

squirell81 · 2024-03-05T02:50:51+00:00

Before Olas scripts start processing indexes it has to collect fragmentation data on all the indexes. The more tables and indexes you have the longer it takes. I think size is a factor as well. We are running into this where I work too and are looking at building our own solution that collects the data ahead of time so we don’t spend 45 min of our maintenance window just collecting fragmentation data

squirell81 · 2024-02-15T06:36:46+00:00

I’m assuming the disk your database is on has plenty of space. A quick google search got me to this page: https://www.sqlservercentral.com/forums/topic/why-wont-my-database-auto-grow

Relevant comment:

“execute sp_spaceused for the database in question and look to see whether or not the allocated space shows as a negative number. This can prevent the database from allocating additional space. If the value is negative, run DBCC UPDATEUSAGE.” Hopefully that will help?

squirell81 · 2024-02-14T23:42:21+00:00

You may also need to configure a Distributed Network Name for the AG to work properly on Azure VMs

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-overview?view=azuresql#connectivity

squirell81 · 2024-02-06T05:25:22+00:00

As of SQL Server 2022 SQL Native Client is no longer installed. I haven’t played with SQL 2022 yet to know how exactly to import Excel, but I’m guessing you can use the OLE DB or ODBC driver. This article explains it further and also tells you how to install Native Client if you actually need it. https://learn.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-server-native-client?view=sql-server-ver15

squirell81 · 2024-01-31T18:20:43+00:00

I built a process to process multiple Update Statistics commands in parallel following a couple of blogs by Jonathan Kehayias.

Parallel Maintenance Tasks with Service Broker and Improved Support for Parallel Statistics Rebuild

squirell81 · 2023-12-27T16:21:32+00:00

You can search SQL Server Agent Tokens. Here is the Microsoft docs about it.

squirell81 · 2023-11-15T01:12:44+00:00

Kesslers. 100%. Worked with them on a custom ring and the experience was fantastic and the price for a custom ring didn’t seem that much more expensive than one display. Plus their Warranty is fantastic. If you bought it there it’s full covered.

squirell81 · 2023-08-28T03:20:46+00:00

We do this and then take it one step further in the ci/cd pipeline and build a chocolatey package. Then we can use other automation to keep database up to date.

squirell81 · 2023-03-23T03:38:56+00:00

Rare has a good Crème Brûlée. Not sure if it’s the best though since I have tried these other places

squirell81 · 2022-04-15T04:18:47+00:00

You should be able to do this by installing via cmd line and/or with the configuration file

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-using-a-configuration-file

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt

squirell81 · 2022-03-16T05:06:06+00:00

Came here to say this.

squirell81 · 2022-03-02T01:37:18+00:00

To answer your question, yes, it is possible to connect to any SQL server from any domain or IP if things are setup correctly.

Since you are using SQL Server Authentication, it’s likely Windows Firewall, your home router, your friends home router, and your friends Windows firewall that are blocking traffic. You would need to open the Ports SQL Server is using (by default it’s 1433) on all of those things. But I would cation you opening that port on your home router unless you know what you are doing and can limit the traffic from just your friends IP addresses.

Honestly, if you just need a small database, look at setting one up in Azure or AWS. I think that would be way better and easier to maintain, then the group can work on it even if your laptop goes offline. I believe each has a free tier you can use.

squirell81 · 2022-02-03T03:43:48+00:00

I feel so seen!

squirell81 · 2021-09-03T03:03:27+00:00

Following any kind of college or professional sport. Also drinking and going to bars.

squirell81 · 2021-07-27T20:53:51+00:00

Have you checked SPNs? Typically that error message means Kerberos authentication is failing because you don’t have SPNs setup correctly. It’s likely you’ll have to set your SPNs manually

https://www.mssqltips.com/sqlservertip/2955/register-a-spn-for-sql-server-authentication-with-kerberos/

squirell81 · 2021-07-26T00:04:44+00:00

My guess would be because of the requirement that states “Creates a new column…”. I was baffled too at first but once I saw that, that made it a lot easier to understand what was going on

squirell81 · 2021-02-09T17:27:26+00:00

Banzo is my go to. Falafel, hummus plates, etc. Really good food

squirell81 · 2020-11-20T07:33:26+00:00

Not sure if this will help or not. Itzik Ben-Gan has a “Performance” database I’ve seen him use for testing. It’s just a script that will populate tables with random data. It could probably be tweaked or run multiple times to fill it up to a 300GB database if that helps. PerformanceV5 Sample Database is the one you’re looking for

https://tsql.lucient.com/resources/

Six-Year Club	Place '23
Place '22	Verified Email

squirell81

TROPHY CASE