Django's ORM vs. Raw SQL: When to Use Which (2024-01-26)

SQLServerCentral Newsletter for January 26, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Django's ORM vs. Raw SQL: When to Use Which]( - [State of the Database Landscape 2024: Shifting skills to match constant demands]( - [SQL WAITFOR Command to Delay SQL Code Execution]( - [From the SQL Server Central Blogs - Friday Flyway Tips–The Version Control Blade]( - [From the SQL Server Central Blogs - T-SQL Tuesday #170 – Learning from Failure]( - [Big Data Analytics with Spark: A Practitioner's Guide to Using Spark for Large Scale Data Analysis]( Question of the Day - [Linux Support]( The Voice of the DBA  A Great Place to Work I have had quite a few employers in my career. Of the ones that paid me for computer work, I'll say that there were 3 great ones (1 I owned), 2 average ones, and 3 poor ones. I've had a few other minor times or contract situations where I didn't really judge or care one way or the other. A lot of time is spent at work, but if it's days/week/(few months), I can deal with most situations. That being said, even at the poor places, I learned a lot and I grew, so I don't regret them or wouldn't want them removed from my past. There are always good and bad things about any job. As I tell my kids, every job is a job some days, even my amazing position at Redgate. Recently my employer, Redgate Software, was on a number of Best Places to Work lists in the US. We took 28th in the US (5th in Austin, 4th in LA, 10th in NY) with higher rankings when you filtered to mid-sized businesses. While I don't work in those places, I do go to our offices, and I think we have an amazing culture, workplace environment, support, and training for staff. We're a mid-sized company now with a bit over 500 people, which is amazing. I was person 146, but I've known the company since it was 8 people. As it's grown, I think Redgate has done a great job under Simon Galbraith's leadership of building a place to work that is productive and profitable, but enjoyable and interesting. Our current CEO, Jakub Lamik, has continued to help Redgate thrive, both as a business and as an employer. Many of you reading this are data professionals in some way and likely work for someone else. Do you think you have a great employer? Are you happy with the workplace, be it in an office, at home, or some combination? Would you vote for your employer as one of the best places to work in your city? I didn't here, but I would. We've regularly made similar lists in Cambridge, UK, where I've most often visited an office. I worked at home for 5 years before I started at Redgate, and since then I've mostly worked at home. I regularly visit offices 4-10 times a year, mostly in Cambridge, but also in Pasadena, Austin, and New York. I appreciate that we built offices that are comfortable to use, with plenty of tech that makes life easy for employees. We are flexible with hours, and even the rules we set in place can flex or bend for individual situations. We hire smart, motivated people, and everyone learns how to both be supportive and accommodating while holding themselves and others accountable for work. I think we are sometimes too nice, but that might be my cut-throat US business upbringing compared to the UK style of work. To be fair, Redgate isn't for everyone, and we have had no shortage of people leave in our 25-year history. We've also had quite a few people leave and come back, realizing not only is the grass not greener elsewhere, there are plenty of worse places to work. I don't love everything about Redgate, but I do enjoy working with a diverse group of people from many different countries and backgrounds, with a very wide variety of experience relating to databases. I learn from many, get ideas from different viewpoints, and get the chance to try and better explain databases (DevOps, monitoring, etc.) from my point of view and experience. I loved working at JD Edwards, and I really enjoyed my partnership with Brian Knight and Andy Warren at SQL Server Central. Redgate is up there with those organizations as a great place to work and one I enjoy almost every day. Can you say the same thing? If not, hopefully, you find your situation more positive than negative. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Django's ORM vs. Raw SQL: When to Use Which]( omu from SQLServerCentral When it comes to building websites, how you work with your database can make a huge difference in how well your site runs. That's especially true if you're using Django, a popular tool for making websites with Python. Django comes with something called an Object-Relational Mapping (ORM) layer, which is a fancy way of saying […] [External Article]( [State of the Database Landscape 2024: Shifting skills to match constant demands]( Press Release from Redgate The key findings from our industry survey reveal how the database landscape has become increasingly complex in recent years. As modern-day business demands and data needs evolve, data professionals and organizations are affected everywhere. Here are the changes coming in 2024 and beyond that you need to know about. [External Article]( [SQL WAITFOR Command to Delay SQL Code Execution]( Additional Articles from MSSQLTips.com One of the most rarely used commands in SQL is the WAITFOR command. It is one option to invoke a delay in program execution in absentia. Because it is sparsely used, how and where it can be applied when needed is often forgotten. For example, we could use this to mimic a user response or input or perhaps to collect data at certain intervals during the day. [Blog Post]( From the SQL Server Central Blogs - [Friday Flyway Tips–The Version Control Blade]( Steve Jones - SSC Editor from The Voice of the DBA The Flyway Desktop Version Control tab is gone and a new blade has appeared in its place. This post looks at the changes and what that means for a... [Blog Post]( From the SQL Server Central Blogs - [T-SQL Tuesday #170 – Learning from Failure]( K. Brian Kelley from Databases – Infrastructure – Security So what did I learn? I think a better question is, "What did I re-learn?" [Big Data Analytics cover]( [Big Data Analytics with Spark: A Practitioner's Guide to Using Spark for Large Scale Data Analysis]( Site Owners from SQLServerCentral Big Data Analytics with Spark is a step-by-step guide for learning Spark, which is an open-source fast and general-purpose cluster computing framework for large-scale data analysis. You will learn how to use Spark for different types of big data analytics projects, including batch, interactive, graph, and stream data analysis as well as machine learning. In addition, this book will help you become a much sought-after Spark expert.   Question of the Day Today's question (by Steve Jones - SSC Editor):  Linux Support What platforms does SQL Server on Linux support for SQL Server 2022 (apart from containers)? 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) Getting a Schema Copy I want to get my schema from a SQL Server 2022 into a DACPAC format that I can use to apply to another database. What options do I use with SqlPackage.exe? Answer: Extract Explanation: The Extract parameter is used to get a dacpac with schema. Ref: SqlPackage - [ [Discuss this question and answer on the forums](    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 2017 - Administration [recovery model for model database]( - Hi All, Is it good to leave "model" database recovery model as "FULL:" or change it to simple? is it just to ensure the newly created user databases to have FULL recovery model or is there any other good reason ? I see log backup pending for model database that's why asking this question.  […] SQL Server 2016 - Administration [List Procedure That Creates A Table]( - I've been trying to develop a process that will take the input of a table name and trace that back to a stored procedure that creates, updates, or inserts into it. I've been piecing together queries using the sys.sql_dependencies, sys.sql_expression_dependencies, dbo.sysobjects, and dbo.syscomments tables but I'm not able to get the results that I'm looking […] [Local admin cannot view/launch failover cluster manager]( - hi all. I am new to this and hope someone can help me. We have created a failover cluster for our SQL. When I log in using a Domain Admin user (Domain\user), I can view the cluster manager. But when I log in using a local admin (local administrator group), I cannot/unable to view the […] SQL Server 2016 - Development and T-SQL [SQL Query requirements]( - Hi All  create table #temptable (idValue int) insert into #temptable values(1) insert into #temptable values(2) insert into #temptable values(3) insert into #temptable values(4) insert into #temptable values(5) insert into #temptable values(6) insert into #temptable values(7) insert into #temptable values(8) insert into #temptable values(9) insert into #temptable values(10) In this above Query I need two […] [what parts of an ssas tabular cube should i version in tfs/dev ops]( - Hi, i want to start versioning the critical portions of my ssas tabular cube in tfs. What should i archive the bim file? SQL 2012 - General [SQL Server 2012 - not accepting new connections on occasion ...]( - SQL Server 2012 running on Windows Server 2012 R2. Microsoft SQL Server 2012 (SP4-GDR) (KB4583465) - 11.0.7507.2 (Intel X86) This occurs occasionally, maybe once every 2 weeks or so, the DB server does not accept new connections. Existing connections are OK, but it will not accept new ones. It requires a restart of the SQL […] [Database mail quit working]( - About a week ago, database mail stopped working. The error message from the log is "Cannot send mails to mail server (Failure sending mail)." the rather generic error message. This is happening both on test emails as well as other production emails I restarted the server, tried temporarily disabling the firewall, recreated the db mail […] SQL Server 2019 - Administration [Size of DB Log File]( - hi I was looking at the size of my db. The log looks really big. It is supposed to be that big? here is the query i used to get this information: SELECT mdf.database_id, mdf.name, mdf.physical_name as data_file, ldf.physical_name as log_file, db_size_MB = CAST((mdf.size * 8.0)/1024 AS DECIMAL(8,2)), log_size_MB = CAST((ldf.size * 8.0 / 1024) […] [SQL Server 2012 - not accepting new connections on occasion ...]( - SQL Server 2012 running on Windows Server 2012 R2. Microsoft SQL Server 2012 (SP4-GDR) (KB4583465) - 11.0.7507.2 (Intel X86) This occurs occasionally, maybe once every 2 weeks or so, the DB server does not accept new connections. Existing connections are OK, but it will not accept new ones. It requires a restart of the SQL […] [Error delete old audit File]( - Hello , I recently set up a SQL database audit to record a few sessions. The audit configuration is well done with retention of 2 files Everything works correctly except that in the error log I have this message which indicates that SQL server can no longer delete the old audit file because it seems […] SQL Server 2019 - Development [Need help with Pivot query or other mechanism to report below data]( - Hi, I've got below dataset (this is sample dataset) I would like to show dataset following way[…]  srv01 srv02 srv03 srv04 srv05 2024-01-22 10:46:00.000 10 20 30 40 50 2024-01-22 10:47:00.000 10 20 30 40 50 Integration Services [Could not find file]( - Please assist. I don't know if the actual file does not exist( it does not exist in mentioned folder) or if the file path in the variables are the problem. Am i jumping the gun here? [Excel Source - Master Data Reference [14]] Error: System.IO.FileNotFoundException: Could not find file '\\ZADURFS01\Departments\Finance\Business Intelligence, Reporting and Analytics (BIRA)\Source […] Suggestions [What is Data Cleansing and what is the importance of Data cleansing for B2B]( - Hello Recently when I was talking to my friends I came to know about data cleansing, they told me that data cleansing will be helpful for B2B database, but I did not know about data cleansing and it is not useful for B2B business. How important it is for you. Please guide me regarding data […] SQL Server 2022 - Administration [Directory CleanupDir is filling up our drive]( - We recently upgraded to SQL Server Analysis Services 2022 and noticed the CleanupDir has almost 3 million files. The location is H:\MSSQL\MSAS15.SSRSPRO\OLAP\Data\CleanupDir. We have tried to manually delete the files, but no progress. There are files older than 30 days. Two questions. What is this directory used for in the SSAS instance? Is there a […] SQL Server 2022 - Development [SQL to insert row with RefNum to be the next numeric number]( - Hi all, I need some help with SQL. I want to create test data by inserting new rows into an existing table using TSQL. Each row has a RefNum column which is in integer and isn't the primary key. RefNum of the new row should be max. value of RefNum in the table + 1 […]   [RSS Feed]( This email has been sent to {EMAIL}. 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -