Viewing 15 posts - 541 through 555 (of 2,356 total)
Can I point PowerBI (on prem) straight at it.
What are you saying here? The users are using Power BI desktop, and need to point to a spreadsheet? Or...
February 3, 2022 at 4:33 pm
And in other news....I have taken the plunge. After almost 25 years as a developer I have just accepted a new position as a full time DBA. Even more...
February 3, 2022 at 3:23 pm
Notifications are working again.
February 3, 2022 at 3:02 pm
It's funny. While there is certainly a lot to be desired about various parts and pieces of SQL Server, what's better?
The original complaint was that SSMS didn't have the same...
February 3, 2022 at 1:30 pm
I'm not sure what your schema should look like, but posting proprietary company data and structures on a public forum would be grounds for immediate termination.
February 2, 2022 at 5:46 pm
To my kind respondents, thank you once again, but I think you're much too understanding towards Microsoft. Personally I'm not impressed.
In comparison to what other cloud database offerings? What are...
February 2, 2022 at 4:46 pm
OK thanks for confirming, but what's the rationale? It's infuriating.
That's probably a question for Microsoft.
But, if you think about it, there is not really a server behind an Azure...
February 2, 2022 at 2:24 pm
Nope. You can see some things in the Azure portal, otherwise it's a SQL Script.
February 2, 2022 at 1:13 pm
At first I thought SQL was under high utilization, but now I'm thinking perhaps the SAN is under high utilization from other VMs, causing our disk IO capacity to...
February 1, 2022 at 9:34 pm
Thank you for your feedback.
If I wanted to insert multiple rows at one time with this stored procedure how would I modify the updated stored procedure to do that?
Pass...
February 1, 2022 at 9:24 pm
Does VidCAD Phoenix have any hardware recommendations?
Do the attached spreadsheets contain a copy of the data that is stored in the database?
When you say "Some functions with a standard computer...
February 1, 2022 at 9:19 pm
If you are using the ROW_NUMBER function to find a specific row and perform an update, then it will likely not work.
The row_number function will return a different row if...
February 1, 2022 at 9:03 pm
Good stuff!
I use the dbatools to do the same things. https://dbatools.io/commands/
There are a few different commands that copy logins and permissions between servers.
I've not delved into DBATools.io much. ...
February 1, 2022 at 7:53 pm
SSRS Standard, as far as I am aware, doesn't support clustering and only allows you to host it on 1 server.
I believe you would need to upgrade to Enterprise...
January 31, 2022 at 3:07 pm
Viewing 15 posts - 541 through 555 (of 2,356 total)