Viewing 15 posts - 2,971 through 2,985 (of 39,818 total)
It's safe, but there are two things to note here.
April 1, 2020 at 3:09 pm
There are different paths here, but as Anthony noted, what are you attempting to do?
https://docs.microsoft.com/en-us/learn/certifications/browse/
You can filter by role, so maybe the Developer role and Certification. You can then...
April 1, 2020 at 2:59 pm
Or just use a testing framework and write a test: https://www.sqlservercentral.com/articles/using-tsqlt-tests-to-practice-queries
April 1, 2020 at 2:51 pm
Glad you enjoyed it. Coming up with something plausible is a fun challenge each year.
SQL Server on Linux (2005) - https://www.sqlservercentral.com/articles/sql-server-on-linux
I would hope we'd see native Python someday, but...
April 1, 2020 at 2:29 pm
Glad you enjoyed it. Trying to come up with something to "get" you is always a fun challenge.
April 1, 2020 at 2:17 pm
You should not have sa being used for SSRS, ETL, etc. It's a recipe for problems, and it's a security risk. Create separate, non-sysadmin, accounts for each access.
If you're struggling...
April 1, 2020 at 2:15 pm
OK, this is a blown question. I meant to specify Azure SQL Database and did so in the tag, but not the question. I have altered that to be clear.
In...
March 31, 2020 at 6:29 pm
The bigger question is, "When will privacy matter more than money?"
And it never will. That ship has sailed.
...
Perhaps. I think that trade was made, but people are rethinking it....
March 31, 2020 at 6:24 pm
I bet it's a split, but we get more WFH options. once companies see some things work, they will. I also think orgs will struggle to say Lynn's ex can...
March 31, 2020 at 6:12 pm
Again, this isn't about whether the government should or shouldn't, but rather the challenge for us in complying and the issues we may face as data professionals.
March 27, 2020 at 8:56 pm
Glad you learned something. That's most of what I'm trying to do with these.
March 27, 2020 at 3:12 pm
SELECT [name], s.database_id,
COUNT(l.database_id) AS 'VLF Count',
SUM(vlf_size_mb) AS 'VLF Size (MB)',
SUM(CAST(vlf_active AS INT)) AS 'Active VLF',
SUM(vlf_active*vlf_size_mb) AS 'Active VLF Size (MB)',
COUNT(l.database_id)-SUM(CAST(vlf_active AS INT)) AS 'In-active VLF',
SUM(vlf_size_mb)-SUM(vlf_active*vlf_size_mb) AS 'In-active...
March 26, 2020 at 2:21 pm
Viewing 15 posts - 2,971 through 2,985 (of 39,818 total)