|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
The Last Valid Restore Time | |
In SQL Server 2022, there is a last_valid_restore_time column in sys.backupset. What is this used for? | |
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) |
Assigning a Server Role I want to create a new Server Role for my SQL Server 2019 instance, but I want another server principal to own this role. What should I do? Answer: Use CREATE SERVER ROLE WITH AUTHORIZATION= Explanation: There is an AUTHORIZATION clause with the CREATE SERVER ROLE that you can use to set the owner. Ref: CREATE SERVER ROLE - https://learn.microsoft.com/en-us/sql/t-sql/statements/create-server-role-transact-sql?view=sql-server-ver16 |
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 |
Does the db_ddladmin database role permissions apply to db system object? - The db_ddladmin is another powerful role because it allows a user to create, drop, or modify any objects within a database, regardless of who owns it. (https://www.mssqltips.com/sqlservertip/1900/understanding-sql-server-fixed-database-roles/). Question1, it states it allows a user to create, drop, or modify 'any objects' within a database, does this include 'system objects' or just 'user objects' within the […] |
SQL Server 2016 - Administration |
Batch Requests/sec ; FROM sys.dm_os_performance_counters -how to get SUM /hour? - Is it possible to query the SUM(cntr_value) for the previous hour ? (for example, to compare it with Sum of the current hour?) (or any other time period, for that matter?) SELECT cntr_value,* FROM master.sys.dm_os_performance_counters WHERE counter_name='Batch Requests/sec'; |
Administration - SQL Server 2014 |
Replacing Physical Server - Hi We are going to update our old SQL physical servers to brand new machines. In the planning in my head stage but need some advice. Thinking I can setup the new hardware with the exact same OS, SQL version, instance name but with a different server name. Then when the new server is setup […] |
SQL Server 2019 - Administration |
Is it best practice to the password for distributor_admin? - Hello, Our audit team has decreed that all logins should password policy turned on for all SQL Server logins. They also decreed that the login password needs to be 32 characters. I found the command to change the password: sp_changedistributor_password The question that I have, is this something that is going to break my replication? […] |
how to minimize prevent sql injection - Hi All, We are having sql injection from website. The login used in the connection having only data reader and execute all SP. We use SP, view and function, no adhoc query. To find we are running server side trace. From that, I have found someone executed SP where this sp do number of items […] |
tran log won't grow. i can't understand why. - My tran log is set to autogrow, by 256 mb, to unlimited. I fill the log but it doesn't grow. I can grow it manually. Why is it not autogrowing? If it's relevant, it's in a 4 replica AG. This is a test db / issue so we're talking small numbers here, MBs. |
SQL Server 2019 - Development |
SQL Developer - ISDATE(OPS_PROJ_FMIS.STATE_OPTION_2) = True Trying evaluate if this OPS_PROJ_FMIS.STATE_OPTION_2 date and keep getting an error How Do I used IsDate Funtions in this? |
Get all StudentIds for each consecutive date - I have a table wherein each student submits their assignment. I need to write a query to get all the students who submitted their assignments each day. So from the table shown, StudentId 1 and 2 submitted their assignments on all 3 days. The output should be 1 and 2. Any hint will be helpful. |
Amazon AWS and other cloud vendors |
AWS CDK | Multi-repository serverless project structure - Hello, everyone I'm trying to split my huge serverless CDK project into separate repositories/services. Everything is fine except one thing: I don't understand how to deal with shared API Gateway. Those multiple separated services should be exposed via one particular API Gateway. Do I need to separate shared resources to different git repository as well […] |
General Cloud Computing Questions |
Is there a reason to use Cloud SQL rather than BigQuery? - I'm studying for the GCP exam and the text made it pretty clear that BigQuery was for large analytics datasets and cloud sql made more sense for small transactional data. But the pricing for BQ just seems insanely lower than cloud sql for smaller data too. I'm working on a personal project that will have […] |
Reporting Services |
Empty Field is causing entire Page to be blank - I'm a little new to SSRS and am running into a strange issue. I have a Table tied to a data source. Essentially, it is just a letter with text and two fields from the dataset ([Salutation] and [FullName]). The [Fullname] is a field that defines the Associate for the record and it may be […] |
Empty Field is causing entire Page to be blank - I'm a little new to SSRS and am running into a strange issue. I have a Table tied to a data source. Essentially, it is just a letter with text and two fields from the dataset ([Salutation] and [FullName]). The [Fullname] is a field that defines the Associate for the record and it may be […] |
update the SSRS branding files - i'd like to update the SSRS branding files. I was wondering if there is a copy of the default branding files that i could download to use as a back up, just in case anything goes wrong? or how can i download and back up the existing branding files in use? If I just add […] |
General |
Partial dependency - A partial dependency occurs when fields are indirectly or partially reliant on the main key but are also dependent on other keys that depend on the primary so that if the field on which another field depends is deleted, that field will still exist owing to its dependence on the primary key. I'm not sure […] |
Integration Services |
Retrieving Active Directory information - I have a requirement to process AD information through an SSIS package and have hit a problem with the "objectClass" attribute. The ADO.NET source is configured as: and the package has converted all of the output data types to NTEXT. This isn't an issue for most of them as I've converted them to DT_STR using […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |