| Filling Big Shoes Hey all! It's me, Grant. For those who don't me, Grant Fritchey. I work with Steve Jones, the person normally talking to you here. Yes, Redgate actually employs me, and continues to. I don't know why either. Anyway, Steve is off for a few weeks on his sabbatical. More power to him and I hope he enjoys the time off. Meanwhile, you're left to the tender mercies of myself, and my amazing co-worker, Kellyn Gorman (you'll hear from her later). We'll be providing you with editorials and the newsletter while Steve is away. I feel just how big the shoes I'm trying to fill truly are. It's a bit daunting. So, my question to you is pretty simple. Have you ever had to do this? Step up into another's role and you're pretty sure you maybe aren't completely up to snuff on it? I'm neck deep in it now. Here's a few things I'm doing about it. First, yeah, I'm straight up acknowledging the fear. Why hide from it. Put it front and center so you can keep an eye on it (fear is pernicious & sneaky). Next, I'm fully recognizing that I'm not Steve and so, I'm not even going to try to be Steve. Instead, I'm going to be Grant, doing Steve's job. Finally, I'm being cautious. I'm very aware that I'm playing in Steve's pool right now, and I'm going to treat it kindly. You know what I mean. When you've hit this particular challenge, what did you do? How did it go? And please, let me and Kellyn know how we're doing. Grant Fritchey Join the debate, and respond to today's editorial on the forums |
|
| Mike McQuillan from SQLServerCentral In this next level of the Stairway to Snowflake, we delve into Event Tables. These are used to capture telemetry from your Snowflake database. |
|
| Additional Articles from Brent Ozar Blog SQL Server 2025 improved PSPO to handle multiple predicates that might have parameter sensitivity, and that’s great! I love it when Microsoft ships a v1 feature, and then gradually iterates over to make it better. Adaptive Memory Grants were a similar investment that got improved over time, and today they’re fantastic. |
|
| Ed Elliott from Ed Elliott's Sql Developer Blog I recently encountered an interesting issue with ADF where the publish feature suddenly attempted to republish every single object, claiming they were new, despite having incrementally published changed objects... |
|
| Kevin3NF from Dallas DBAs Useful tips to make your jobs more stable Too many IT teams treat SQL Server Agent jobs like a coffee timer “Set it and forget it!” Unfortunately, that mindset... |
|
| Grant Fritchey from SQLServerCentral Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan correction, and other advanced features now available in SQL Server. |
|
| Today's question (by Steve Jones - SSC Editor): |
| | Adding More Data To Sample Databases |
| I have installed the WideWorldImporters database from Microsoft on my SQL Server 2022 system. There is some data included, but it's all from before 2013. How can I more quickly add more random data to my sample database? |
| Think you know the answer? Click here, and find out if you are right. |
| | Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2019 - Administration |
| Batchmode execution in SQL 2019 - Is there a way to force a query to use Batchmode execution, my database is in 2019 compatibility mode. For some reason, my queries are not using batch mode even when its scanning through millions of rows. Is there a query hint or in anyway to force it to use Batch mode execution (SQL server […] |
| Migrating Temporal/systemversioned Tables - Hello, for my client i have to do regular refreshes of production to dev. We have been automating this in the belief the full DB has to be refreshed but now we are asked to keep certain schemas from dev when refreshing. These schemas have together around 25 temporal Tables which i have written about […] |
| SQL Server 2019 - Development |
| is there a way to have a table sorted automatically? - Hi Everyone I have one table that has a unique requirement to be sorted in order for the table to have any value. I remember the sort order now but in the future I may forget the order and have to spend time to figure out why the data doesn't look right in the table. […] |
| BULK INSERT question - Hi everyone I have a text file that I want to import into SS table. I can import the file but the problem is that order isn't preserved. Suppose the file has below entries: Line1 Line2 Line3 When the above gets imported into SS table it is presenting them as Line2 Line3 Line1 The order […] |
| SUM([value]) and highest record type - Given a record mapping table: Id Initial Updated 1 1 2 2 3 4 3 6 5 and a data table: Id Model RecordType Value 1 1 1 3.00 2 1 2 5.00 3 2 3 2.00 4 3 6 1.00 5 3 5 2.00 I want to SUM([Value]), grouped by the [Model] but also […] |
| should i expect data types in task->export data from ssms? - Hi i recently exported a number of "to be purged resultsets " to .tsv's. this is a related link https://www.sqlservercentral.com/forums/topic/is-there-a-reorg-available-in-sql-server . my next step was to see how i'd fare trying to rehydrate to a table with the same cols and data types from one of these tsv's, specifically one with high volume (9 […] |
| Azure Data Factory |
| Connecting ADF to take information from sharepoint and from Confluence - Dears, Hope this message finds you well Using Azure Data Factory, Issue 1: I want to connect to Confluence to extract information from confluence pages into HTML format and place them into a folder in my landing zone (Azure datalake). Confluence Cloud REST API via ADF HTTP or REST Connector What do you think is […] |
| Don't want to connect to the high transactional on-premises SQL Server Database - Dears, Hope this message finds you well We have a on-premises transactional database which is heavily used for transactions. Issue : We are creating a chatbot which will query the database so that users can make questions in natural language and get replies in SQL. This is all done by the AI, But for that, […] |
| Anything that is NOT about SQL! |
| Need help in changing my displayname - How do I change my display name, in my edit profile there are only drop down options available. No option available to edit existing displayname. thanks inadvance. |
| Editorials |
| Three Times a Day - Comments posted to this topic are about the item Three Times a Day |
| A Well Deserved Break - Comments posted to this topic are about the item A Well Deserved Break |
| SQLServerCentral.com Website Issues |
| Error: There was a problem subscribing. - I am seeing this error when I try to subscribe to a post. Anyone else? |
| Article Discussions by Author |
| How to Work with RStudio and SQL Server - Comments posted to this topic are about the item How to Work with RStudio and SQL Server |
| Why Clone Fails: Discovering the Hardware Beneath Azure SQL MI - Comments posted to this topic are about the item Why Clone Fails: Discovering the Hardware Beneath Azure SQL MI |
| SQL Server 2022 - Development |
| Better way to set order of selections/precedence order? - Our application sells products from various distributors. Each buyer has a "precedence order" when it comes to their most to their least favorites distributors. For ex: BuyerA can have precedence order of (Vendor2 is favorite, Vendor 1 is second choice, Vendor 3 is last choice) assuming that there are only 3 potential distributors. BuyerB can […] |
| This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. |
|
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com |
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
